Post reply

collation conflict in sqlserver 2005

  • February 2, 2011 at 12:17 am

    #148329

    Hi,

    we are facing the collation conflict in sqlserver 2005

    we are using windows server 2008 & sqlserver 2005 DEV Edition

    after installing sqlserver 2005 (default) instance in above windows box .

    checked in the server properties collation : Latin1_General_CI_AI

    we restored out client DB into our server Now DB collation it is showing : SQL_Latin1_General_CP1_CI_AS

    we are facing the Collation conflict issue from application end

    EXEC with some ---------- dateformat(yyyy-mm--dd)& ------ yyyy-mm--dd

    error message :

    ERROR cannot resolve collation conflict between " SQL_Latin1_General_CP1_CI_AS" and " Latin1_General_CI_AI" in the equal

    any sugession/solution to fix this collation issue.

  • February 2, 2011 at 1:11 am

    #1281267

    The server collation determines the collation for system databases (master, model, tempdb, msdb).

    Probably some procedure makes use of temporary tables, created on tempdb, hence the collation conflict.

    I would create a new instance with the same collation as the customer server.

    Home this helps

    Gianluca

    -- Gianluca Sartori

  • February 2, 2011 at 10:14 pm

    #1281716

    Hi,

    Thanks for the reply

    My DB collation is SQL_Latin1_General_CP1_CI_AS

    i want to install sqlserver 2005 Edition (with above collation )on windows server 2008 box .

    when i nstall default collation it is installing collation like

    Latin1_General_CI_AI

    but how to install this (SQL_Latin1_General_CP1_CI_AS) while installation which option i need to select .

    Iam getting Collation Conflict with client DB restoration with server collation

    Please reply

  • February 3, 2011 at 11:32 pm

    #1282272

    please update

  • February 4, 2011 at 1:37 am

    #1282300

    jamessdba (2/3/2011)

    please update

    Sure! Just don't be so impatient... We are all volunteers on these forums and we answer questions during our free time.

    To set the collation during setup, you have to uncheck the "Hide advanced configuration options" checkbox:

    Then you can select the collation from the list. The one you are looking for is showing on this picture:

    Hope this helps.

    Gianluca

    -- Gianluca Sartori

  • February 4, 2011 at 2:19 am

    #1282316

    Thank you very much for updates

    i will try this.

  • February 4, 2011 at 3:05 am

    #1282333

    i canged & installed with the above option

    its working fine GREATTTTTTTTTTTT

    Thank a ton

  • February 4, 2011 at 3:08 am

    #1282334

    You're welcome.

    Glad I could help.

    -- Gianluca Sartori

Viewing 8 posts - 1 through 7 (of 7 total)

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