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 

Calling Talend Open Studio Users

The first 100 community members completing the Open Studio survey win a $10 gift voucher.

Start the survey

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 4

Pick up some tips and tricks with Context Variables

Blog

How Media Organizations Achieved Success with Data Integration

Learn how media organizations have achieved success with Data Integration

Read

Definitive Guide to Data Integration

Practical steps to developing your data integration strategy.

Download