Reading a string in unicode format.

Question

0.00/5 (No votes)

See more:

Hello,

I have a table in SQL Server 2008 which contains string in various format for e.g. ASCII,UTF-8 etc.I need to read this string in unicode format.

Is there any direct query like collate... or anything else to solve this.

Please share your solution.

Reagrds,
Sachin

Posted 12-Jun-12 2:02am

cancerion

Add a Solution

2 solutions

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

Manas Bhardwaj · Answer 1 · 2012-06-12T02:09:00

Solution 1

That depends on how your data is stored in SQL Server. All unicode data must be stored in columns with datatype N(type) e.g. nvarchar, ntext, nchar

Look at MSDN documentation:

http://msdn.microsoft.com/en-us/library/aa933104(v=sql.80).aspx[^]

Posted 12-Jun-12 2:09am

Manas Bhardwaj

Comments

Prasad_Kulkarni 12-Jun-12 8:23am

5'ed!

cancerion 12-Jun-12 8:28am

Actually in table data can be stored in utf-8 ,ascii ,unicode or any other format , it will not surely in 1 format, so just we want to make sure when retreiving using stored procedure we get in unicode format.

Prasad_Kulkarni · Answer 2 · 2012-06-12T02:23:00

Solution 2

C# (and .Net in general) handle unicode strings transparently, you won't have to do anything special unless your application needs to read/write files with specific encodings.

Strings in C# are Unicode by default. Try

C#

string converted = Encoding.Unicode.GetString(data);

where data is a byte[] array containing your Unicode data. If your data is big endian, you can try

C#

string converted = Encoding.BigEndianUnicode.GetString(data);

Have a look on similar discussions;
C# read unicode[^]
Unicode & C#[^]

Posted 12-Jun-12 2:23am

Prasad_Kulkarni

Comments

cancerion 12-Jun-12 8:35am

Thanks for reply..

Actually i am looking for a solution at sql server level,we perform some operation on unicode data. some query to get column values saved in different formats into unicode format.

cancerion 13-Jun-12 2:19am

Hello,

in a table i have data is utf-8 format for e.g.
Carrer de BÃ©jar
Calle de Antonio Machado
Calle del CanÃ³nigo Domenech
Carrer de Pau ArpÃ i GalÃ
Calle del Abad Oliba

I want them to read in unicode format ,In database in extended property collation is set as 'SQL_Latin1_General_CP1_CI_AS'

Regards,
Sachin