language-font problem

[Elvira Zeinalova]

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]

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.z...@sff.no> skrev i melding
news:VX%Qd.9095$Sl3.2...@news4.e.nsc.no...

[Erland Sommarskog]

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, esq...@sommarskog.se

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