Want to protect your cyber security and still get fast solutions? Ask a secure question today.Go Premium

x
?
Solved

Replication character translation error

Posted on 2006-05-22
5
Medium Priority
?
315 Views
Last Modified: 2006-11-18
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
0
Comment
Question by:Floppsey2
  • 2
3 Comments
 
LVL 24

Expert Comment

by:Joe Woodhouse
ID: 16754981
Suspect you mean Sybase ASA and SQL Remote? (I thought you meant Replication Server until I saw the version numbers...)

I would be checking the character sets used by ASA on both sides and SQL Remote. It definitely could be using a different set.
0
 

Author Comment

by:Floppsey2
ID: 16770123
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
0
 
LVL 24

Accepted Solution

by:
Joe Woodhouse earned 1000 total points
ID: 16770160
I've not heard anything about character sets being phased out. It seems very unlikely! Sybase is spending more and more effort on internalisation, not less...

But yes, definitely have the character sets agreeing for every moving part here - ASA (source and destination) and SQL Remote should all agree. It shouldn't matter quite so much that they match the server character set but it isn't a bad idea...
0

Featured Post

Free Tool: Site Down Detector

Helpful to verify reports of your own downtime, or to double check a downed website you are trying to access.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Are you a startup company? Being a startup, you may be using shared hosting, or maybe even dedicated hosting. But have you ever given a thought to using cloud computing now? Yes, don’t be surprised, it is possible for startups to opt for cloud compu…
The article explains the process to deploy a Self-Service password reset portal I developed a few years ago. Hopefully, it will prove useful to someone.  Any comments, bug reports etc. are welcome...
this video summaries big data hadoop online training demo (http://onlineitguru.com/big-data-hadoop-online-training-placement.html) , and covers basics in big data hadoop .
Whether it be Exchange Server Crash Issues, Dirty Shutdown Errors or Failed to mount error, Stellar Phoenix Mailbox Exchange Recovery has always got your back. With the help of its easy to understand user interface and 3 simple steps recovery proced…

577 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question