If too late for this release, consider it a request for the next release: Provide a way (pragma, or additional syntax on the command/virtual table) to have the command-line .import, and the new CSV virtual table, use NUMERIC column affinity when creating a new table.
I like to think that 10 is greater than 2. Unfortunately .import creates a table where that is not true. Thanks, Bill -----Original Message----- The next release of SQLite will be the "pi" release - version 3.14. ************************************************************************************** This e-mail and any attachments thereto may contain confidential information and/or information protected by intellectual property rights for the exclusive attention of the intended addressees named above. If you have received this transmission in error, please immediately notify the sender by return e-mail and delete this message and its attachments. Unauthorized use, copying or further full or partial distribution of this e-mail or its contents is prohibited. ************************************************************************************** _______________________________________________ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
