One Star

Error type with tCreateTable

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 ?
2 REPLIES
Employee

Re: Error type with tCreateTable

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
One Star

Re: Error type with tCreateTable

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