Character sets and sort orders.greenspun.com : LUSENET : SQL Server Database Administration : One Thread
I am using SQL server 6.5 with visual basic 5. I need to know internationalise it all, and therefore I am looking for any relevant information. Could you poss help me with information of the charactersets and sort orders to be used in Europe, ie Spain, Italy, Germany, France, Netherlands, Switzerland.
Many thanks for your time
-- Anonymous, January 18, 1999
Look in your SQL \install directory for instlang.sql, run that, select * from master..syslanguages to see the list of languages and then use sp_defaultlanguage to change the language that is used for each login.
-- Anonymous, January 19, 1999