Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 SQL Server 2000 Forums
 SQL Server Development (2000)
 Multi Language Support in 1 table

Author  Topic 

AskSQLTeam
Ask SQLTeam Question

0 Posts

Posted - 2004-06-02 : 07:15:36
Jan-Willem writes "Well first let me thank you for giving me this opportunity to ask a question.
Installed: Windows 2003 advanced server, SQL 2000 with SP3

We are an small Dutch intnernational company and in our database we are willing to have all customers: Chinese, Israelean, Dutch, Belgium and French customers. We store those customers into the same tabel.
This part works fine. We use nvarchar for storage for eg companyname. Storing goes fine and reading also BUT when we search for the companies we get no results, only for the Dutch, French and Belgium Customers. The windows 2003 server has been set to English Char set with support for Hebrew and Chinese.

Ehat should be the correct statement to be able to read either Chinese, Hebrew and English text.

To make my point I cannot convert the text behind where since I don't know which language has been given to search for.

Can you help me out.

By the why MS Access doesn't have this problem MySQL has even more problems.

Thanks in advance"
   

- Advertisement -