Elvira Zeinalova (elvira.zeinalova@sff.no) writes:
> In my application I need to make the report in different languages.
> I made a table for report parameters, like:
>
> create myTable (
> language_id int not null,
> parameter char(50) null,
> constraint PK_lang_ID PRIMARY KEY (language_id))
>
> and then tried:
> insert into myTable values(1, 'Bank info') - for English
> insert into myTable values(2, '????') - for Chinese.
>
> it worked OK ( I have installed "Chinese" language in server)
> but when run:
> select * from myTable
> then I get:
> 1 Bank info
> 2 ?????
>
> And in Application it is also coming like: "????"
> What is wrong ? Do I have to do some additional installation staff for
> Chinese in SQL Server ?

You should probably specify parameter to be nchar(50) and the character
literal as N'????', and thus work with Unicode.


--
Erland Sommarskog, SQL Server MVP, esquel@sommarskog.se

Books Online for SQL Server SP3 at
http://www.microsoft.com/sql/techinf...2000/books.asp