This SQL works well for English data, but if I try to insert Japanese data on my US English Windows 2000 server, all of the characters inserted into the database are broken. Yes, you are right. Luckily, Dr. International can assure you that you are not crazy. The answer to this question is actually in the SQL Server Books Online, hidden in a topic named Using Unicode Data . This causes a slight performance hit for the query because of the two extra conversions, but it also causes strings to be corrupted if they are not on your server's default system code page.
Users can set their language in the browser.
If you are using IE, You can also change your Regional Settings and have the browser automatically pick up your new language choice. This string, now sitting in the stLang variable, can be used in many different ways to control the content of your site. Transfer or Server. Execute methods to move to a localized page. If you try to call SetLocale on this string, you will find out that it fails with a runtime error.