Re: [sqlite] SQLite 3 manifest typing question

2005-07-20 Thread Sergey Tarasov
ample database backups, and i need these scripts to run correctly on SQLite 3. Is there any quick hack allowing me to change SQLite 3 and make it to look at the column definition to determine type of a data value when processing INSERT statements (like the SQLite 2.8 does)? Many thanks, Sergey Ta

[sqlite] SQLite 3 manifest typing question

2005-07-20 Thread Sergey Tarasov
Hello All, I'm having a problem with the 'manifest typing' concept used in SQLite3. The problem is as follows: 1. I have a table in SQLite 2.8 database, containing list of city telephone codes. It is important that the codes are text values because leading zeros is significant in this case. So t