Post reply

How to known the value of unicode comparison style

  • June 30, 2004 at 12:20 am

    #83075

    Hi everybody,

    I want to see which value is the unicode comparison style of my SQL7 server, but i dont know how.

    Because i want to restore a backup of a database from another server, and i've got an error message on different unicode locale ID (1033) or unicode comparison style (196608). As  the unicode locale ID (1033) is the same on the 2 servers (i've use the sp_helpsort ), i suppose that the problem is the unicode comparison style...

    Thanks for help

  • July 5, 2004 at 8:00 am

    This was removed by the editor as SPAM

  • December 14, 2004 at 1:55 pm

    #533846

    Hi,

    To see your current Unicode Comparison Style, you must use sp_configure to enable advanced options and again to retrieve the number:

    sp_configure 'show advanced options', 1

    GO

    RECONFIGURE

    GO

    sp_configure

    GO

    by the way,

    Unicode Comparison Style Number 196611 is 'General Unicode', with 'Case Insensitive', 'Accent Insensitive', 'Width Insensitive' and 'Kana Insensitive'

    and Unicode Comparison Style Number 196609 is 'General Unicode', with 'Case Insensitive', 'Width Insensitive' and 'Kana Insensitive'.

    Does anyone know about a complete table?

    Best Regards

    JP Negri

    MAPS RMS

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

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