Replication character translation error

Posted on 2006-05-22
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?

Sybase 9.0.2 2451
Windows Server 2003 SP1

Please let me know if you need more information.

Thank you!

Question by:Floppsey2
    LVL 24

    Expert Comment

    by:Joe Woodhouse
    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.

    Author Comment

    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.

    LVL 24

    Accepted Solution

    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...

    Write Comment

    Please enter a first name

    Please enter a last name

    We will never share this with anyone.

    Featured Post

    Top 6 Sources for Identifying Threat Actor TTPs

    Understanding your enemy is essential. These six sources will help you identify the most popular threat actor tactics, techniques, and procedures (TTPs).

    I've been asked to discuss some of the UX activities that I'm using with my team. Here I will share some details about how we approach UX projects.
    DECT technology has become a popular standard for wireless voice communication. DECT devices are not likely to be affected by other electronic devices and signals because they operate in a separate frequency-band.
    Internet Business Fax to Email Made Easy - With eFax Corporate (, you'll receive a dedicated online fax number, which is used the same way as a typical analog fax number. You'll receive secure faxes in your email, fr…
    In this seventh video of the Xpdf series, we discuss and demonstrate the PDFfonts utility, which lists all the fonts used in a PDF file. It does this via a command line interface, making it suitable for use in programs, scripts, batch files — any pl…

    761 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

    Need Help in Real-Time?

    Connect with top rated Experts

    7 Experts available now in Live!

    Get 1:1 Help Now