[sqlite] Re: Re: Insert chinese characters in SQLite database

2007-12-13 Thread Igor Tandetnik
Kalyani Phadke wrote: Yes , It worked. Could you pls tell me whats the difference between adLongVarWChar and adLongVarChar? Does SQLite support Unicode encoding(UTF-8)? SQLite does support UTF-8. But I suspect ADO actually converts the data to Windows current code page when adLongVarChar is s

Re: [sqlite] Re: Re: INSERT: how to include CR & LF symbols in a string constant?

2007-11-14 Thread Simon Davies
On 14/11/2007, Jevgenijs Rogovs <[EMAIL PROTECTED]> wrote: > Sounds too complicated for this simple situation... > Can anything be done w/o coding? > Why not change INSERT INTO sometable VALUES ('blablabla\r\nyadayadayada'); into INSERT INTO sometable VALUES ('blablabla yadayadayada'); (real r

Re: [sqlite] Re: Re: INSERT: how to include CR & LF symbols in a string constant?

2007-11-14 Thread Jevgenijs Rogovs
Sounds too complicated for this simple situation... Can anything be done w/o coding? On Nov 14, 2007 3:53 PM, Igor Tandetnik <[EMAIL PROTECTED]> wrote: > Jevgenijs Rogovs <[EMAIL PROTECTED]> > wrote: > > Thanks, but how do I use those? > > See, I have a huge file of INSERT statements, which look

[sqlite] Re: Re: INSERT: how to include CR & LF symbols in a string constant?

2007-11-14 Thread Igor Tandetnik
Jevgenijs Rogovs <[EMAIL PROTECTED]> wrote: Thanks, but how do I use those? See, I have a huge file of INSERT statements, which look like this: INSERT INTO sometable VALUES ('blablabla\r\nyadayadayada'); Prepare a single statement of the form INSERT INTO sometable VALUES (?); Then read your

[sqlite] Re: Re: Insert

2007-02-28 Thread Igor Tandetnik
Christian POMPIER <[EMAIL PROTECTED]> wrote: De : Igor Tandetnik [mailto:[EMAIL PROTECTED] Christian POMPIER <[EMAIL PROTECTED]> wrote: Could i make to insert 10 000 row in my table with a loop ? Yes. But what is the good syntax ? The syntax of the INSERT statement is described here: http

RE: [sqlite] Re: Re: Insert triggers

2006-01-25 Thread nbiggs
Ah, Ha! I got it to work. Thanks for your help. -Original Message- From: Igor Tandetnik [mailto:[EMAIL PROTECTED] Sent: Tuesday, January 24, 2006 5:31 PM To: SQLite Subject: [sqlite] Re: Re: Insert triggers Dennis Cote wrote: > Igor Tandetnik wrote: >> SQLite does no

[sqlite] Re: Re: Insert triggers

2006-01-24 Thread Igor Tandetnik
Dennis Cote wrote: Igor Tandetnik wrote: SQLite does not support cascading triggers. Operations performed by a trigger never cause other triggers to run. This is not true. SQLite supports multiple triggers on the same event (insert, update, or delete) on a single table and it fires all trigge