Can't make Talend Open Studio write to UTF8 firebird database

Not applicable

Can't make Talend Open Studio write to UTF8 firebird database

tFirebirdInput_1 uses "win1257" encoding.
tFileOutputCSV_1 have corect values encoded in UTF8 when I open the file. (only if there is not connection between tMap_1 to tFirebirdOutput_1 ("called DB (Main order:3)"))
tLogRow_1 also displays correct values.
I also tried writing form CSV encoded in UTF8 directly to tFirebirdOutput_1, but it didn't worked too.
If I use database output encoded in not UTF8 (for example we use "UNICODE_FSS") then it works, but only Latin characters being written (second picture).
Output databases are the same except encoding.
I got this error when trying to write in UTF8 database (first picture)
Starting job Copy_Companies at 09:19 04/09/2007.
736|1|Zaras? DB|||||||838538002|||||||1
Exception in component tFirebirdOutput_1
org.firebirdsql.jdbc.FBSQLException: GDS Exception. 335544849. Malformed string
at org.firebirdsql.jdbc.AbstractPreparedStatement.internalExecute(AbstractPreparedStatement.java:712)
at org.firebirdsql.jdbc.AbstractPreparedStatement.executeUpdate(AbstractPreparedStatement.java:172)
at bandymas2.copy_companies.Copy_Companies.tFirebirdInput_1Process(Copy_Companies.java:1356)
at bandymas2.copy_companies.Copy_Companies.main(Copy_Companies.java:1549)
at org.firebirdsql.gds.GDSException: Malformed string
at org.firebirdsql.gds.impl.wire.AbstractJavaGDSImpl.readStatusVector(AbstractJavaGDSImpl.java:2124)
at org.firebirdsql.gds.impl.wire.AbstractJavaGDSImpl.receiveResponse(AbstractJavaGDSImpl.java:2074)
at org.firebirdsql.gds.impl.wire.AbstractJavaGDSImpl.iscDsqlExecute2(AbstractJavaGDSImpl.java:1155)
at org.firebirdsql.gds.impl.GDSHelper.executeStatement(GDSHelper.java:224)
at org.firebirdsql.jdbc.AbstractPreparedStatement.internalExecute(AbstractPreparedStatement.java:708)
at org.firebirdsql.jdbc.AbstractPreparedStatement.executeUpdate(AbstractPreparedStatement.java:172)
at bandymas2.copy_companies.Copy_Companies.tFirebirdInput_1Process(Copy_Companies.java:1356)
at bandymas2.copy_companies.Copy_Companies.main(Copy_Companies.java:1549)
Job Copy_Companies ended at 09:19 04/09/2007.
Copy_Companies.java:1356 is "pstmt_tFirebirdOutput_1.executeUpdate();"
Copy_Companies.java:1549 is "Copy_CompaniesClass.tFirebirdInput_1Process();"

long end = 0;
long start = java.util.Calendar.getInstance().getTimeInMillis();
Copy_Companies Copy_CompaniesClass = new Copy_Companies();
try {
Copy_CompaniesClass.tFirebirdInput_1Process();
} catch (TalendException e) {
status = "failure";
e.printStackTrace();
} finally {
end = java.util.Calendar.getInstance().getTimeInMillis();
if (watch) {
System.out.println((end - start) + " milliseconds");
}
}
Any suggestions?
Employee

Re: Can't make Talend Open Studio write to UTF8 firebird database

Hello,
Caqn you create a bug in our Bugtracker
Regards,
Michaël.
Not applicable

Re: Can't make Talend Open Studio write to UTF8 firebird database

Hello,
Caqn you create a bug in our Bugtracker
Regards,
Michaël.

Yes, I've already created a report.
One Star

Re: Can't make Talend Open Studio write to UTF8 firebird database

Has this been solved?
I have a read from Firebird database encoding problem. If I manually insert encoding into db connection it is not working 

2019 GARNER MAGIC QUADRANT FOR DATA INTEGRATION TOOL

Talend named a Leader.

Get your copy

OPEN STUDIO FOR DATA INTEGRATION

Kickstart your first data integration and ETL projects.

Download now

What’s New for Talend Summer ’19

Watch the recorded webinar!

Watch Now

Best Practices for Using Context Variables with Talend – Part 1

Learn how to do cool things with Context Variables

Blog

Migrate Data from one Database to another with one Job using the Dynamic Schema

Find out how to migrate from one database to another using the Dynamic schema

Blog

Best Practices for Using Context Variables with Talend – Part 4

Pick up some tips and tricks with Context Variables

Blog