SQL Server Query Unicode String

Question

I have a table UserType:

 id (int),
 type nvarchar(50)

I have inserted some rows into that table

 INSERT INTO [UserType] VALUES (N'កក្កដា');
 INSERT INTO [UserType] VALUES (N'វិច្ឆិកា');

And it's successfully inserted.

Then when I tried to query it back

select * 
from [UserType] 
where type=N'កក្កដា';

It returns all rows.

What's wrong? Please help!

are you serious what does the * in your query mean.. you are telling it to select * from [UserType] where type=N'កក្កដា'; perhaps you should alter your query to only return UserType also do a google search on how to return Unicode String from Sql Server I would also recommend reading up on what SELECT * means here is a start for you msdn.microsoft.com/en-us/library/ms180059.aspx — MethodMan
– MethodMan, Commented Jan 27, 2015 at 16:24
I have edited your title. Please see, "Should questions include “tags” in their titles?", where the consensus is "no, they should not". — John Saunders
– John Saunders, Commented Jan 27, 2015 at 16:29

Pரதீப் · Accepted Answer · 2015-01-27 16:31:11Z

6

Looks like you database is Accent Insensitive.

You need to explicitly mention the proper collation name in where clause to filter the proper data.

Use Latin1_General_100_CI_AS collation which is accent sensitive. Try this.

SELECT *
FROM   [UserType]
WHERE  type = CONVERT(NVARCHAR(50), N'វិច្ឆិកា') COLLATE Latin1_General_100_CI_AS;

answered Jan 27, 2015 at 16:31

Pரதீப்

94.1k21 gold badges144 silver badges179 bronze badges

Sign up to request clarification or add additional context in comments.

2 Comments

It's working fine now , But I don't want to use COLLATE Latin1_General_100_CI_AS in the query.Is there any way?

@ChhornSoro - Try altering your database collation