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" <el**************@sff.no> skrev i melding
news:VX*******************@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

[Erland Sommarskog]

Elvira Zeinalova (el**************@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, es****@sommarskog.se

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