View Issue Details

IDProjectCategoryView StatusLast Update
0003534SymmetricDSBugpublic2025-04-02 17:38
Reportergilles.riand Assigned To 
Prioritynormal 
Status acknowledgedResolutionopen 
Product Version3.7.36 
Summary0003534: Character set issue with replication between Interbase and Postgresql
DescriptionHello
Here My Nodes definitions

- Master (Interbase)
|- Store1_DATABASE_IB ((Interbase)
|- Store1_DATABSE_PG (Postgresql)
  |- PointOfSale1_DATABASE_PG(Postgresql)
  |- PointOfSale2_DATABASE_PG(Postgresql)
|- Store2_dataBASE_IB (INTERBASE)
|- Store2_DATABSE_PG (Postgresql)
  |- PointOfSale3_DATABASE_PG(Postgresql)
  |- PointOfSale3_DATABASE_PG(Postgresql)

The replication works fine between all nodes except with the Euro Symbol between IB en PG

It's because the Interbase databe are in charset NONE en PG in UTF8 WIN1252 (french.france)

>IB Nodes
wrapper.java.additional.18=-Dfile.encoding=ISO8859_15
And I can't modified this value ! because it's the only way to do replication between my IB databases

I tyr PG Nodes
wrapper.java.additional.9=-Dfile.encoding=utf-8
wrapper.java.additional.18=-Dfile.encoding=ISO8859_15
...Etc.... and other it's never the good solution...







Tagscharacter encoding

Activities

cquamme

2025-04-02 17:38

developer   ~0002756

You could try adding charset='utf8' to the JDBC url.

Issue History

Date Modified Username Field Change
2018-04-30 13:33 gilles.riand New Issue
2019-04-29 14:10 elong Summary Replication Interbase / Postgresql => Character set issue with replication between Interbase and Postgresql
2019-04-29 14:10 elong Project SymmetricDS Pro => SymmetricDS
2019-04-29 14:11 elong Tag Attached: character encoding
2025-04-02 17:38 cquamme Note Added: 0002756
2025-04-02 17:38 cquamme Status new => acknowledged