Advanced SQL is not support Japanese Language?

Advanced SQL is not support Japanese Language?

  

Hi there,


I want to use Advanced SQL to create a search function that applicable for foreign language. 

I know in Aggregate it will work without problem but I need to query multiple table then union it to distinct the result.


Here is my SQL code and data.

After I did the test, It's worked fine with English


But when I test in Japanese, It didn't worked as following.


Anyone know how to solve this problem? Did I miss something?


Thank you 

Solution

Hi Chaiwat,

Dunno if this could be the case but on SQL 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.

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

Regards,

Marcelo

Solution

Marcelo Ferreira wrote:

Hi Chaiwat,

Dunno if this could be the case but on SQL 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.

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

Regards,

Marcelo


Thank you so much! I worked perfectly.