[EMAIL PROTECTED] a écrit :
So the question is: should this be changed. Should SQLite ignore leading space in strings when trying to determine if the string looks like a number.
[...]
Which is the correct behavior? Is this important enough to change (and possible cause problems in legacy code)?
As you said in a previous mail : "Other RDBMSes do similar automatic conversions. If you try to insert a string into an integer column of other database and the string looks like an integer, the database will do the conversion for you. If the string does *not* look like an integer, however, most other database engines will throw an error. SQLite does not do this. It goes ahead and stores the string. The unusual behavior of SQLite is considered a feature, not a bug." i would say that you can "improve" automatic datatype casting, but where to go ? Does SQLite have to take in charge what a developper doesn't want to do himself (ie removing leading and trailing spaces) ? IMHO, i would let things like they're now. Regards, -- Guillaume MAISON - [EMAIL PROTECTED] 83, Cours Victor Hugo 47000 AGEN Tél : 05 53 87 91 48 - Fax : 05 53 68 73 50 e-mail : [EMAIL PROTECTED] - Web : http://nauteus.com