SQL Server 2008 search double byte characters

Question

Is there a way to tell which records are double byte character in SQL Server 2008?

For example, I want to query all records in Chinese, Korean and Japanese in a table if country filed is blank, how can I do it?

Your input is really appreciated.

I think I might have confused you guys. Everything is stored in nvarchar. Some records are in Chinese, some are in Korean, Some are in Spanish and more. We want to find out the Chinese, Japanese and Korean records to do something about it. Does that make sense?

Answer 1

Is there a way to tell which records are double byte character in SQL Server 2008?

You can use this - if the double-byte character cannot be reduced to a single byte, then you have CJK in the record:

select * from tbl
where convert(nvarchar(max),convert(varchar(max),somecolumn)) != somecolumn