Post reply

Sybase ASE to SQL Server 2008 R2 migration. Issue in Collation Sequence

  • May 24, 2012 at 11:45 am

    #257031

    Hi All,

    My employer has recently migrated a database from Sybase ASE 12.5.3 to SQL Server 2008 R2.

    After the migration, if I try to store a certain special character "bullet point" through the Java application, it is getting stored as a different value.

    But the same "bullet point" is written to the database correctly, if I use the query editor in SSMS.

    Have any one noticed this kind of issue before..?

    Is it because of the collation?

    Can you help me?

    Thanks!

    Siva.

  • May 24, 2012 at 5:27 pm

    #1492891

    I suspect that this has more to do with the client settings than the server's.

    [font="Times New Roman"]-- RBarryYoung[/font], [font="Times New Roman"] (302)375-0451[/font] blog: MovingSQL.com, Twitter: @RBarryYoung[font="Arial Black"]
    Proactive Performance Solutions, Inc.     [/font]    [font="Verdana"] "Performance is our middle name."[/font]

  • May 26, 2012 at 10:20 am

    #1493522

    Hi,

    Thanks for your response. I think the same too. Not sure if you have faced a similar situation before..

    Regards,

    Siva.

  • May 26, 2012 at 12:27 pm

    #1493531

    I saw something like this a long time ago. As I recall it had something to do with the code page settings on the clients.

    [font="Times New Roman"]-- RBarryYoung[/font], [font="Times New Roman"] (302)375-0451[/font] blog: MovingSQL.com, Twitter: @RBarryYoung[font="Arial Black"]
    Proactive Performance Solutions, Inc.     [/font]    [font="Verdana"] "Performance is our middle name."[/font]

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

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