Post reply

What could be the difference?

  • April 20, 2007 at 2:31 pm

    #69000

    I am trying to compare data between sql7 and Oracle db's and I am getting different results for 2 different sql servers that I believe are configured the same. There are some fields that I

    am comparing that have special characters that do not seem to be translating the same between the two SQLServers. When I query the Oracle db using a linked server on SQLServerA, the data is returned as (Saint-Saëns). However, if I query the OracleDB using SQLServerB, the result is (Saint-Saens) without the umlaut. Is there a configuration setting that I have overlooked on the SQLServer B that can correct this issue? What could be the difference between my 2 SQLServer DB's?

    SQLServers A & B

    v.7

    CP 1252

    OS Win2000

    NLS CodePage OEMCP 1252

    Oracle client

    AMERICAN_AMERICA.WE8MSWIN1252

    Thanks,

    Todd

  • April 23, 2007 at 8:53 am

    #701946

    Todd,

    Sounds like the two servers are having a different collation. When you create a linked server you can set some options like which collation the linked server should use (remote, local or any other one). Look on the Server options tab for your linked server to see what is currently configured.

    I must admit I never had to deal with these issues, but I suppose playing around with this settings should solve your problem.

    Markus

    [font="Verdana"]Markus Bohse[/font]

  • April 23, 2007 at 9:12 am

    #701954

    Thanks Markus...I just looked at your suggestion and it appears that under the server options, I can only toggle "Collation Compatible" on or off. I do not see the ability to remote or local?

    I did try it both ways and it did not seem to correct the issue. Is there a direct statement syntax you know of where I can test the collation

    something like this: ( i cant seem to get the syntax correct)

    select columnA

    from ORACLE_LNKSRV..SCHEMA.TABLE

    where OBJ_ID COLLATE Compatibility_52_409_30003 = 1234

    (also not sure of the collate portion above. i have used this type of statement to resolve this issue between sql7 and sql2000)

    thanks again,..

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

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