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 |
|
BeijingJay
Starting Member
1 Post |
 Posted - 2005-08-22 : 07:36:59
|
| Hi,I've setup a full-text search catalog on an nvarchar column which is populated with English and Chinese character strings. When searching in English, query results return as expected. However, when searching in Chinese, the only time results are returned is if the entire string of Chinese characters for one record is entered. I want results to be returned for even a single Chinese character match.An analogy for clarification:Let's say I have a table of book names. I want to type in one character from the title of the book and get any results which contain that single character. As it is right now, I would have to type in the entire title of the book to get a result!Right now my best guess is that the problem is related to collation, as I believe the DB is setup for default collation and not Chinese_PRC. However, the nvarchar column could potentially contain data in many different languages, so I'm not sure how to handle this. Any help would be greatly appreciated. Thanks! |
|
|
|
|
|
SQL2000 Chinese character search