topic Re: MySQLbulkexec incorrectly loading bit and date datatype columns in Talend Studio

MySQLbulkexec incorrectly loading bit and date datatype columns

Anonymous — Mon, 01 Aug 2016 15:19:48 GMT

HI,
I am using TOS. I am outputting the data from a table in sql server to a file. It has boolean and dates columns.
Later I am using mysqlbulkexec to load to a table in mysql.
However, even though the load is successful and all rows are loaded. The bit columns are all loaded with 0 values while in the original sql server table there were values of 1 as well.
The dates are loaded as

0000-00-00 00:00:00

Any ideas on this would be helpful

Thanks in advance
Rathi

Re: MySQLbulkexec incorrectly loading bit and date datatype columns

Anonymous — Mon, 08 Aug 2016 09:16:14 GMT

Hi,
What does your loading data look like? How did you set your data type in schema setting? More information will be preferred.
Best regards
Sabrina

Re: MySQLbulkexec incorrectly loading bit and date datatype columns

Anonymous — Thu, 11 Aug 2016 19:34:06 GMT

Hi,

Try to change the page code type to "ACP" or "OEM" and the type data file to "CAR" under Advanced settings of your component