You are not logged in.
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
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.
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 ?