Re: [sqlite] SQLite 3 manifest typing question

2005-07-20 Thread Sergey Tarasov
rasov. - Original Message - From: "Downey, Shawn" <[EMAIL PROTECTED]> To: Sent: Wednesday, July 20, 2005 6:03 PM Subject: RE: [sqlite] SQLite 3 manifest typing question Thank you for your response. Unfortunately for you, I believe that most peoples response wou

RE: [sqlite] SQLite 3 manifest typing question

2005-07-20 Thread Downey, Shawn
SQLite 3 manifest typing question > > 3. Now i dump my SQLite 2.8. database using .dump command and got > following > script: > BEGIN TRANSACTION; > create table codes(code TEXT); > INSERT INTO codes VALUES(00); > INSERT INTO codes VALUES(011); > COMMIT; > > 4. It

Re: [sqlite] SQLite 3 manifest typing question

2005-07-20 Thread John LeSueur
3. Now i dump my SQLite 2.8. database using .dump command and got following script: BEGIN TRANSACTION; create table codes(code TEXT); INSERT INTO codes VALUES(00); INSERT INTO codes VALUES(011); COMMIT; 4. It works great when recreating the SQLite 2.8 database, but when run on This looks

RE: [sqlite] SQLite 3 manifest typing question

2005-07-20 Thread Downey, Shawn
110 Clifton Park, NY 12065 518-371-3983 x3 (work) 860-508-5015 (cell) -Original Message- From: Sergey Tarasov [mailto:[EMAIL PROTECTED] Sent: Wednesday, July 20, 2005 6:08 AM To: sqlite-users@sqlite.org Subject: [sqlite] SQLite 3 manifest typing question Hello All, I'm having a pr

[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