How to identify unicode text in SQL?

Question

0.00/5 (No votes)

See more:

Table1 has nvarchar column called umsg which contains unicode text and some time english also.

I want to find out English text present in umsg column.

select * 
from table1 
where 
    RDate >='01/01/2014' and RDate < '09/26/2017' 
    and umsg = convert(varchar(max), umsg)

I used above query that work fine in regional language but some time fail. Suppose col contain text like 'ref no Ã©tÃ©' I think above message is unicode, if I used above query, it/sql is showing me as English not unicode.How to handle this.

What I have tried:

select * 
from table1 
where 
    RDate >='01/01/2014' and RDate < '09/26/2017' 
    and umsg = convert(varchar(max), umsg)

Posted 2-Oct-17 18:43pm

Member 11589429

Updated 2-Oct-17 20:31pm

Add a Solution

1 solution

Add a Solution

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

Satyanand Bhardwaj · Answer 1 · 2017-10-02T20:31:00

Solution 1

Try this it's working ....

create table #test (
   uni nvarchar(100) 
)

insert into #test (uni) values (N'法的書面'),( 'asdf'), (N'Foo'), ('Bar')

select *
from #test
where uni <> convert(varchar(max), uni)

Posted 2-Oct-17 20:31pm

Satyanand Bhardwaj

How to identify unicode text in SQL?

1 solution

Solution 1

Add your solution here

Preview 0

How to identify unicode text in SQL?

1 solution

Solution 1

Add your solution here

Preview 0

Existing Members

...or Join us