Replication does not preserve character encoding Firebird 5

FirebirdSQL / firebird

Firebird server, client and tools

https://www.firebirdsql.org/

1.19k stars 205 forks source link

Replication does not preserve character encoding Firebird 5 #8107

Closed Michel-Itapira closed 3 weeks ago

Michel-Itapira commented 3 weeks ago

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

dyemanov commented 3 weeks ago

Is this field blob or varchar?

Michel-Itapira commented 3 weeks ago

varchar

dyemanov commented 3 weeks ago

It's replicated exactly as stored. Maybe you connect to the replica using different (unicode) connection charset and thus see different data?

Michel-Itapira commented 3 weeks ago

Sorry blob

Michel-Itapira commented 3 weeks ago

Blob Text

Michel-Itapira commented 3 weeks ago

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

dyemanov commented 3 weeks ago

If it's a blob, then it looks like #7969. Try the fresh snapshot build.