On Tue, Feb 21, 2012 at 9:07 PM, Bob Burger <[email protected]> wrote:
> > The license for David Gay's dtoa.c is not compatible with SQLite.
>
> Thanks for checking into it, and I'm very sorry to hear it's incompatible.
> Our software uses the SQLite binary interface to bind parameters in most
> cases, but there are a few occasions when users specify queries in text.
>
> What would you think of providing a configuration option for SQLite to use
> the strtod C library function?
>
strtod() doesn't work in all cases since it depends on locale - the radix
point character is usually 0x2e (".") but is sometimes 0x2c (",").
Strtod() could be made to work if we could guarantee that the locale always
specified 0x2e as the radix point character.
Also, strtod() requires UTF8 text whereas SQLite sometimes has the content
as UTF16. The string-to-binary converter for SQLite is able to handle
both. The inability of strtod() to convert UTF16 could be worked around by
doing UTF16-to-UTF8 conversions when necessary. But that would be still
more code that would need to be added and tested.
>
> Bob
> _______________________________________________
> sqlite-users mailing list
> [email protected]
> http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
>
--
D. Richard Hipp
[email protected]
_______________________________________________
sqlite-users mailing list
[email protected]
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
