which sql server version you using?

This topic was automatically closed 365 days after the last reply. New replies are no longer allowed.
12 years ago
Hi all
I wonder what version you are using to develop your nop-sites?

As a developer of multi-lingual sites today for the first time I`ve confronted with this error:

" Cannot resolve the collation conflict between "Latin1_General_CI_AS" and "SQL_Latin1_General_CP1_CI_AS" in the equal to operation."

My server has just Latin1_General_CI_AS - because of this fact this error actually occurs.

Spanded couple of hours of my life researching the issui I discovered that the option of SQL_Latin1_General_CP1_CI_AS used today mostly in case of the transition from earlier versions to sql 2005 + .

So my question is :

why is SQL_Latin1_General_CP1_CI_AS still used in the new versions of NOP

and not it the time to move on Latin1_General_CI_AS to avoid such problems?
12 years ago
Anyway, solved by adding "collate SQL_Latin1_General_CP1_CI_AS" to the "Nop_ProductLoadAllPaged" procedure
as a temporary solution
This topic was automatically closed 365 days after the last reply. New replies are no longer allowed.