February 16, 2009 at 2:48 pm
Hi,
We've got an app that's going to be (eventually) supporting at least English, German and Asian characters, so initially we selected SQL_Latin1_General_CP850_BIN2 for the DBs' collation, but we've now run into an issue where the German characters (like ß and ü) are not being displayed correctly within the DB. The German characters display correctly under SQL_Latin1_General_CP1_CI_AS, but that doesn't do me any good for when we start importing data from Asia.
Was I mistaken in my understanding that CP850_BIN2 was supposed to be a superset of SQL_Latin1_General_CP1_CI_AS?
Thank you in advance for any insight that y'all can provide.
Best Regards,
Beth
February 16, 2009 at 2:58 pm
BIN(binary sort) is the fastest sort but also case sensitive by default so BIN is usually used if you cannot change the collation. And you cannot store the latin alphabet and Chinese in one collation. So check the thread below and choose your collation as needed.
http://www.sqlservercentral.com/Forums/Topic655592-149-1.aspx#bm655808
Kind regards,
Gift Peddie
February 16, 2009 at 3:02 pm
Hi GP,
Thank you for the swift response. I appreciate your help with this. 🙂
Best Regards,
Beth
February 16, 2009 at 3:05 pm
I am glad I could help.
🙂
Kind regards,
Gift Peddie
Viewing 4 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply