Post reply

how to resolve a collation conflict between sql_latin1_general_cp850-bin and sql_latin1_general_cp850-bin2 in is operato

  • April 10, 2011 at 3:16 am

    #97820

    hi,

    anyone can help me on this?

    thanks,

    nilotpal

  • April 10, 2011 at 5:23 am

    #1309601

    Either in your JOIN or your WHERE clause you reference two columns with a different collation.

    You need to define one collation you'd like to use.

    Something like

    SELECT *

    FROM @t1 t1

    INNER JOIN @t2 t2

    ON t1.col1=t2.col1 COLLATE sql_latin1_general_cp850_bin


    Lutz
    A pessimist is an optimist with experience.

    How to get fast answers to your question[/url]
    How to post performance related questions[/url]
    Links for Tally Table [/url] , Cross Tabs [/url] and Dynamic Cross Tabs [/url], Delimited Split Function[/url]

  • April 12, 2011 at 9:23 am

    #1310462

    Collation issues can be very simple or very complex. Collations are implemented at fairly granular levels of database objects, but are defaulted at higher levels (database / server level).

    What's the situation? Are you trying to join to tables (as exampled above) with fields of differing collations, or do something else?

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

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