Error type with tCreateTable

[Anonymous]

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 ?

[Anonymous]

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

[Anonymous]

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