Multilingual data/different charsets

[jose74]

Hi,
I have the problem to save data of different languages in a table in MS SQL 2000.
The data is stored in one Column (nvarchar) and is connected with a foreign key to the specific language.
It contains english and japanese values with different fonts.
Is it possible to do a search over this column and get results of both languages (e.g. where column like N'a%') or is any tool available? The japanese fontset also has synonyms for this letter.

 

[mrdenny]

You would need to do an or clause and include both language versions.

SQL doesn't translate it just stores.

select *
from table1
where (c1 = N'EnglishSearch' or c1 = N'JapaneseSearch') /*With the JapaneseSearch using the JapaneseCharacters.*/

Denny
MCSA (2003) / MCDBA (SQL 2000) / MCTS (SQL 2005) / MCITP Database Administrator (SQL 2005)

--Anything is possible. All it takes is a little research. (Me)

http://www.mrdenny.com

 

[jose74]

Is there something like an Idn-Mapping-tool helpfull (e.g. in .net 2.0) to translate the japanese characters to ascii? - because the user inputs only characters of one language! Does someone know something like that?