Chinese characters (double byte)

Question

Post reply

Chinese characters (double byte)

adrianne agsolid

SSC Enthusiast

Points: 191
More actions
June 22, 2005 at 1:30 am

#88746

I need to setup my SQL server in order to accept data with chinese characters. How can do that?

Viewing 13 posts - 1 through 12 (of 12 total)

You must be logged in to reply to this topic. Login to reply

sushila SSC-Dedicated Points: 35293 More actions · Answer 1

Read up on "Collations" on BOL - it should be a good starting point and gives you detailed information!

**ASCII stupid question, get a stupid ANSI !!!**

Ninja's_RGR'us SSC Guru Points: 294069 More actions · Answer 2

Didn't you just say to me yesterday that you didn't like bol sometimes???

(adrianne - just search there, it's really the best place to start)

sushila SSC-Dedicated Points: 35293 More actions · Answer 3

Yes Remi - the keyword is "sometimes"....

**ASCII stupid question, get a stupid ANSI !!!**

adrianne agsolid SSC Enthusiast Points: 191 More actions · Answer 4

Does double byte data accepted in reporting services? i mean would it be possible that the double byte data (chinese characters) will display in my report?

sushila SSC-Dedicated Points: 35293 More actions · Answer 5

Are you talking about unicode - like nchar etc.. ???

**ASCII stupid question, get a stupid ANSI !!!**

adrianne agsolid SSC Enthusiast Points: 191 More actions · Answer 6

adrianne agsolid

SSC Enthusiast

Points: 191

June 22, 2005 at 6:43 am

#567378

yes

adrianne agsolid SSC Enthusiast Points: 191 More actions · Answer 7

adrianne agsolid

SSC Enthusiast

Points: 191

June 22, 2005 at 6:44 am

#567380

Is unicode and double byte different?

sushila SSC-Dedicated Points: 35293 More actions · Answer 8

As far as I know - No!

Here's a link to the MS website that should help...

http://msdn.microsoft.com/library/?url=/library/en-us/architec/8_ar_da_6ttf.asp

**ASCII stupid question, get a stupid ANSI !!!**

adrianne agsolid SSC Enthusiast Points: 191 More actions · Answer 9

I've already visited that link, that's all about collation in SQL server right? What I would like to know is that is it possible for the reporting services to display data with chinese characters?

adrianne agsolid SSC Enthusiast Points: 191 More actions · Answer 10

adrianne agsolid

SSC Enthusiast

Points: 191

June 22, 2005 at 6:57 am

#567399

Thank you for your replies. I really appreciate it.

sushila SSC-Dedicated Points: 35293 More actions · Answer 11

Adrianne - maybe you should post this under the "Reporting Services" forum - you might have more luck there!

I've only had to use default collations so have never had to learn about international characters....

**ASCII stupid question, get a stupid ANSI !!!**

David A. Long SSCrazy Eights Points: 8421 More actions · Answer 12

SQL Server 2000 UniCode nchar, nvarchar, ntext datatypes allow you to store the chinese characters.

I am not a Reporting Service expert, but I suspect that the user will only see the language's characters if the viewer has installed that language in Internet Explorer.

I do not know about saving the report to a file, though.

Andy