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.
| 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 SP3We 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" |
|
|
|
|
|