Post reply

unicode

  • September 30, 2009 at 6:42 am

    #136319

    I was wondering how one can tell the language of the text in an nvarchar column.

    My client software seems to detect this automatically. (Malaysian , Thai, hungarian....)

    But is there any function/procedure within sqlserver that can tell what language/collation the text is ?

  • September 30, 2009 at 8:41 am

    #1059992

    You can view the collation of the column by using

    SELECT TABLE_NAME, COLUMN_NAME, COLLATION_NAME FROM INFORMATION_SCHEMA.columns

    This will show you what the collation of the column is, but as collation is concerned with the ordering and comparison rules it will not neccesarily define what the data is inside the column

  • October 1, 2009 at 2:40 am

    #1060325

    I am not interested in the collation of the column.

    I wonder how to detect the language of the content. Windows does this for me, and if i have the correct languages installed, it can show me the content.

    Is there a function, proceudre or clr that can tell me what language, collation or unicode charaters are used in the column ?

Viewing 3 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply