[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

Reply via email to