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

_AnonymousUser — Sat, 16 Nov 2024 14:33:29 GMT

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?

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

Anonymous — Wed, 05 Sep 2007 20:43:51 GMT

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

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

_AnonymousUser — Mon, 10 Sep 2007 13:15:35 GMT

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

Yes, I've already created a report.

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

veryimportantdude — Fri, 13 Feb 2015 08:40:47 GMT

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

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

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

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

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

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