Replication does not preserve character encoding Firebird 5
Michel-Itapira opened this issue · 7 comments
Scenario:
2 virtualized Debian servers, identical copies, include Firebird conf and database , database is same both have field ISO8859_1.
When you configure one database for replica and another for master,
if the field is encoded to ISO8859_1 , the data is replicated in UNICODE,
Example:
Data in master
"Dispositivo não foi encontrado com essa chave"
Data replicate in replicate
"Dispositivo não foi encontrado com essa chave"
Change HEX 0xE3 to 0xC3 0x A3
Is this field blob or varchar?
varchar
It's replicated exactly as stored. Maybe you connect to the replica using different (unicode) connection charset and thus see different data?
Sorry blob
Blob Text
It's replicated exactly as stored. Maybe you connect to the replica using different (unicode) connection charset and thus see different data?
Same connection change ip only