<div>
Suspect you mean Sybase ASA and SQL Remote? (I thought you meant Replication Server until I saw the version numbers...)<br />
<br />
I would be checking the character sets used by ASA on both sides and SQL Remote. It definitely could be using a different set. 
</div>


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.

<div>
Yes, that is what I ment, thanks. <br />
<br />
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. <br />
<br />
I will try to do a rebuild on this test db with cp1252 and see if that works. <br />
<br />
J
</div>


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

<div>
<div class="content wysiwyg-content">
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? <br />
<br />
Specs<br />
Sybase 9.0.2 2451<br />
Windows Server 2003 SP1<br />
<br />
<br />
Please let me know if you need more information. <br />
<br />
Thank you! <br />
<br />
J<br />

</div>
</div>


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


Replication character translation error

Sybase, a subsidiary of SAP, builds a client/server relational database management system. Products include Adaptive Server Enterprise (ASE), Adaptive Server Anywhere (ASA), Sybase Unwired Platform (SUP) for mobile applications, Afaria for enterprise mobile device management and IQ for data warehouse and big data applications.