topic Error type with tCreateTable in Talend Studio

Error type with tCreateTable

Anonymous — Sat, 16 Nov 2024 14:33:12 GMT

From a Delimited file schema, I'm trying to create a Mysql table.
One column is 9.00000 for first row, and I don't know which type to choose ?
I tried String for delimited schema and VARCHAR in MySQL schema
Float in delimited schema and FLOAT in MySQL schema
Float in delimited schema and VARCHAR in MySQL schema
and the message is always :

Exception in component tCreateTable_2
com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: For float(M,D), double(M,D) or decimal(M,D), M must be >= D (column 'prix_public_euro').

Any idea ?

Re: Error type with tCreateTable

Anonymous — Tue, 18 Sep 2007 22:05:44 GMT

Hello
Can you switch to the code tab and show us the CREATE TALBE statement generated when you choose

String for delimited schema and VARCHAR in MySQL schema

. This should not generate an exception float precision.
Regards,
Michaël

Re: Error type with tCreateTable

Anonymous — Wed, 19 Sep 2007 08:53:52 GMT

Yes, I've done my job with String and Varchar.
The problem was bad delimiters and chars encapsulating data in Properties of my FileInputDelimited, the quotes were in the string
"0.09" => float problem