How to select rows with Chinese-Japanese characters?

Question

How can I filter a column by Chinese-Japanese like characters? I am trying to do something like

SELECT * FROM my_table WHERE column LIKE '%[A-Za-z]%'

Is it possible for Chinese or Japanese characters?

Answer 1

When working with unicode string you will always need to prefix your string with N to tell sql server explicitly that there can be unicode characters in the operation. INSERT, UPDATE, SELECT and DELETE its true for all operations.

In your case when selecting data, in where clause you will need to prefix the Search string with N. Something like this....

SELECT * 
FROM my_table 
WHERE column LIKE N'%[A-Z]%' --<-- using Japanese characters here 
OR    Column LIKE N'%[a-z]%' --<-- using Japanese characters here