September 15, 2011 at 4:10 pm
Hello,
We have a column in a table which only accepts english characters. We have an requirment to make it accept chiense character. Below things I have tried,
1. Changed the data type from char to nchar.
2. changed to collation for the column in the table to Chinese_PRC_CI_AS.
3. Now when i input data into the column the DB stores in DB as ????
I am not sure why this is happening.
Any suggestions here would be appreciated.
September 15, 2011 at 4:25 pm
When you are viewing the data, how are you viewing it (e.g. what is that you are doing to see the ?'s)?
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events
September 15, 2011 at 4:30 pm
For now I am viewing directly from the data base table.
September 15, 2011 at 4:49 pm
Are you selecting the data through a query, or are you opening the table in SSMS such that you can click and edit the data?
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events
September 15, 2011 at 5:04 pm
Also, when inserting these characters into the database - are you specifying that the values are unicode?
e.g.
Insert Into Sometable (MyNCharField)
Select N'someValue')
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events
September 15, 2011 at 7:11 pm
hi, i am using a sql query i.e. select * from tablename
Viewing 6 posts - 1 through 5 (of 5 total)
You must be logged in to reply to this topic. Login to reply