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 ?


Any idea will be helpful and greatly appreciated

I see that the chinese letters are turned to "????" in my previous mail
also.
When I "insert" for Chinese - I write the Chinese letters in "insert into
......" statement and it is OK.
The problem is I cannot get the same font back when "select"

Please help

"Elvira Zeinalova" <elvira.zeinalova@sff.no> skrev i melding
news:VX%Qd.9095$Sl3.276248@news4.e.nsc.no...
> 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 ?
>
>
> Any idea will be helpful and greatly appreciated
>
>

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