Floppsey2
asked on
Replication character translation error
Sybase Replication is translating a single tic character into the Latin AE symbol. I narrowed this down to replcation and then was stumped. The single tic saves correctly in the Sybase database but the first two insert statements like this failed replication but changed these tics to AEs. Since then I no longer recieve the errors but all tics are automatically changed to the AE characters. Is it possible that replication uses a different ASCII code set than the database?
Specs
Sybase 9.0.2 2451
Windows Server 2003 SP1
Please let me know if you need more information.
Thank you!
J
Specs
Sybase 9.0.2 2451
Windows Server 2003 SP1
Please let me know if you need more information.
Thank you!
J
ASKER
Yes, that is what I ment, thanks.
Ok, I am showing the server using cp1252 and the database using cp437. I heard a rumor that Sybase is going to phase out cp437 completely but could not find any backup notes on that.
I will try to do a rebuild on this test db with cp1252 and see if that works.
J
Ok, I am showing the server using cp1252 and the database using cp437. I heard a rumor that Sybase is going to phase out cp437 completely but could not find any backup notes on that.
I will try to do a rebuild on this test db with cp1252 and see if that works.
J
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
I would be checking the character sets used by ASA on both sides and SQL Remote. It definitely could be using a different set.