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

Reading/Updating/Inserting the Unicode data using sql server 2005

P: 33
Hi All,

I am using Sql server 2005 as a backend for my application. I want to read/write the unicode data using sql query.

When I am using

insert into UnicodeData values('سي') command and if we view the data using sql query analyser, it shows ??.

On the otherhand, when i insert the same unicode data through sql enterprize manager simply copying the data in the actual field, it properly stores the data.

Can anybody help me on how to add/update/retrive the unicode data using the sql query in sql server 2005.

Regards
Amol Lokhande
Dec 26 '08 #1
Share this Question
Share on Google+
3 Replies


Delerna
Expert 100+
P: 1,134
seems like your front end might be taking the unicode character codes and converting them to something else before sending them to the backend database?

What are you using as the front end?
Dec 28 '08 #2

P: 1
I am also having the same problem in inserting the unicode data from front end

Regards
Manish Trikha
Jan 8 '09 #3

P: 13
Wrong - I think you have created the Table with VARCHAR Data type, it won’t accept the Unicode data. Check the below example
Create table UnicodeData (Uni_Code varchar(100))
Insert into UnicodeData values (N'سي')
select * from UnicodeData
Output
------
??

Correct - created the Table with NVARCHAR Data type, it will accept the Unicode data. Check the below example
Create table UnicodeData1 (Uni_Code nvarchar(100))
Insert into UnicodeData1 values (N'سي')
select * from UnicodeData1
Output
------
سي
Jan 9 '09 #4

Post your reply

Sign in to post your reply or Sign up for a free account.