inserting foreign language (help)

[csphard]

Hi I created the following table
CREATE TABLE [myTest] (
[test] [nvarchar] (1000) COLLATE Traditional_Spanish_BIN NULL
) ON [PRIMARY]
GO

try to insert chinese using
insert into myTest(test) values (N'?????? ???')

the data in query analyzer display boxes instead of the language like it does here. What am I doing wrong.

Howard

 

[SQLDenis]

>.What am I doing wrong.


nothing is wrong, use a webserver to display the data and it will be displayed just fine

Denis The SQL Menace
--------------------
SQL Server Code,Tips and Tricks, Performance Tuning
SQLBlog.com, Google Interview Questions

 

[csphard]

I do not understand your answer. So are you saying when I insert the information into the database it will not display in that language. However when I read it to the screen it will if I use the weberver. How do I use the webserver to do this.

Howard

 

[gmmastros]

Additionally, you can set the results to text to display it.

Click Tools -> Options. Click Results tab. Change 'Default results target' to 'Results to Text'.


-George

"The great things about standards is that there are so many to choose from." - Fortune Cookie Wisdom

 

[SQLSister]

Just out of curiousity if you want Chinese, why are you using a collation for Spanish?

"NOTHING is more important in a database than integrity." ESquared

 

[SQLDenis]

I had the same problem once with BIG5 Chinese Characters

In QA I See blocks, if you copy the data and paste it into word it should display the 'correct' way

?????88?? this I just copied from the table

Denis The SQL Menace
--------------------
SQL Server Code,Tips and Tricks, Performance Tuning
SQLBlog.com, Google Interview Questions

 

[SQLDenis]

That is funny when editing the post the show up correctly, anyway copy and paste it into word and they will show

Denis The SQL Menace
--------------------
SQL Server Code,Tips and Tricks, Performance Tuning
SQLBlog.com, Google Interview Questions

 

[csphard]

I copied some Aremenian text. I inserted it into the table.

When I display it in query analyzer it looks different.

When I display that different text in work it does not convert it back. The chinese does. Meaning I can copy some chinese text. Insert into the db. In the table it displays as squares. In word it displays correct.

Can anyone tell what I am doing wrong?

Howard