Post reply

DB collation

  • November 8, 2004 at 12:53 am

    #66330

    I have a database , where some of the tables have  different collation than the database collation , which creates some problem in the application , where the join is happening between two tables with different collation .

    I want a script that allow me to change the collation for all the database char fields.

    Regards

  • November 9, 2004 at 5:40 am

    #529426

    We had this problem, but didn't want the hassel of evaluating the impact of changing  the schema so decided just to cast when joining.

    e.g. If DatabaseA contains TableA, and DatabaseB contain TableB to join using (say) ColC, then assuming you are currently in DatabaseA, you would do:

    SELECT *

    FROM TableA as ta

    INNER JOIN DatabaseB..TableB  as tb ON ta.ColC = tb.ColC collate database_default

    Hope this helps.

     

    Jeet


    Thanks Jeet

  • November 10, 2004 at 4:01 am

    #529584

    Thanks  alot for this

    Regards

    zarifa

     

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

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