This is the answer from Doug at BMC You must pick a unicode character set to support all of the listed languages. There is no other character set that will support the mixture you have specified.
There is a case insensitive version of unicode and that is what they need. I don't know the specific name but hopefully the fact that you want case insensitive unicode leads you to the option you need. -----Original Message----- From: Joe Martin D'Souza <[email protected]> To: arslist <[email protected]> Sent: Sun, Dec 26, 2010 1:41 pm Subject: Appropriate MS-SQL character set - MS-SQL 2008 ** Looks like my posting yesterday the first time around didn’t make it so here is my second try..... Would anyone happen to know what would be the name of the most appropriate character set to select for a MS-SQL 2008 server so that it supports case insensitivity as well as all of the following languages? 1) English 2) French 3) Spanish 4) Italian 5) German 6) Portuguese 7) Japanese The DBA I am working with found sets that support Japanese OR German and all the other languages but not BOTH Japanese and German and all other languages.. Case insensitivity support would also be needed. Any hints would be appreciated.. Cheers Joe _attend WWRUG11 www.wwrug.com ARSlist: "Where the Answers Are"_ _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug11 www.wwrug.com ARSList: "Where the Answers Are"
