467,149 Members | 1,324 Online
Bytes | Developer Community
Ask Question

Home New Posts Topics Members FAQ

Post your question to a community of 467,149 developers. It's quick & easy.

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

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
  • viewed: 6618
Share:
3 Replies
Delerna
Expert 1GB
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
I am also having the same problem in inserting the unicode data from front end

Regards
Manish Trikha
Jan 8 '09 #3
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.

Similar topics

7 posts views Thread by Paige | last post: by
14 posts views Thread by el_sid | last post: by
1 post views Thread by JayCallas@hotmail.com | last post: by
4 posts views Thread by Geoff | last post: by
reply views Thread by Peter Newman | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.