Search code examples
sqlsql-serverchinese-localenon-english

How to find non english language and its data in a table of sql server

I have a Sql Server table loaded with data from multiple countries. Say Japanese, Thai, Urdu, Portuguese, Spanish and many more which i didn't identify.

How to identify the language and its relevant data from that table ?

sample:

colid  |  colname
1      |  stackoverflow
2      |  龍梅子, 老貓

i need a query to produce :

stackoverflow, english
龍梅子, 老貓 , chinese

is this possible to get ?

Solution

  • You might try this:

    DECLARE @str NVARCHAR(100)=N'龍梅子, 老貓';
SELECT UNICODE(Left(@str,1))

    The result is 40845

    A google search on unicode 40845 brought me here.

    It seems to be the dragon or emperor from chinese character set

    Some more information upon unicode character ranges

    The given code points to CJK Unified Ideographs

    UPDATE

    In order to use this:

    You will either have to