[resolved] Cannot read from win-1250 Firebird database properly

[Anonymous]

Hello,
I am quite new to Talend, but so far I've manage to set up a few jobs seemingly fine.
Im using TOS DI 5.3.1

The big Issue I have encountered is, how to set the talend to read from Firebird databse, encoded in win-1250 charset.
All the Czech characters are depicted as "?" in a rectangle (known issue here).
There is no setting in the tFirebirdConnection component, regarding the charset. Neither there is an option for this charset in Preferences > workspace.
Since I am Czech, and I want to read from many production databases, where i cannot affort to change the encoding to UTF-8 for instance, I really need to get this working, since TDI is such a powerful tool.
I am sensing it might have something to do with the jdbc driver I am using, so I have tried this:
http://stackoverflow.com/questions/13156329/firebird-jdbc-driver-connection-character-encoding
but with no avail.
Has anyone any idea how to solve this issue?
I might be able to provide a sample database to test it on.

[Anonymous · Accepted solution]

Wow, I've been trying to find the solution for nearly 2 days now, shamefully I must admit that only now, Ive tried to replace the jaybird JAR file in lib directory by the newer version (frmo 2.1.1. to 2.2.3.), while maintaining the original filename (not sure about the dependencies in Talend), and guess what?? It works!!

[Anonymous]

Hi,
Thanks for sharing your experience with us.
Best regards
Sabrina