By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
446,156 Members | 1,004 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 446,156 IT Pros & Developers. It's quick & easy.

language-font problem

P: n/a
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
Jul 23 '05 #1
Share this Question
Share on Google+
2 Replies


P: n/a
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

Jul 23 '05 #2

P: n/a
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
Jul 23 '05 #3

This discussion thread is closed

Replies have been disabled for this discussion.