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

[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 specified, not to 
UTF-8. You know - Control Panel | Regional and Language Options | 
Advanced | Language for non-Unicode Programs.


Igor Tandetnik 



-
To unsubscribe, send email to [EMAIL PROTECTED]
-

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

[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 return rather than 'C-style escapes')

That works here (XP sqlite3.4.2)

Rgds,
Simon

-
To unsubscribe, send email to [EMAIL PROTECTED]
-

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

[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 like this:
> >
> > INSERT INTO sometable VALUES ('blablabla\r\nyadayadayada');
>
> Prepare a single statement of the form
>
> INSERT INTO sometable VALUES (?);
>
> Then read your file and from each line extract the actual string value,
> without quotes and with \r and \n replaced by actual CR and LF
> characters. Bind this string to the parameter of the statement
> (sqlite3_bind_text), call sqlite3_step and sqlite3_reset. Repeat for
> each line.
>
> Igor Tandetnik
>
>
>
> -
> To unsubscribe, send email to [EMAIL PROTECTED]
>
> -
>
>

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

[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 file and from each line extract the actual string value, 
without quotes and with \r and \n replaced by actual CR and LF 
characters. Bind this string to the parameter of the statement 
(sqlite3_bind_text), call sqlite3_step and sqlite3_reset. Repeat for 
each line.


Igor Tandetnik 



-
To unsubscribe, send email to [EMAIL PROTECTED]
-

[sqlite] Re: Re: Insert

[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://sqlite.org/lang_insert.html

The syntax for creating a loop can be found in a manual for your 
programming language of choice.


Igor Tandetnik 



-
To unsubscribe, send email to [EMAIL PROTECTED]
-

[sqlite] Re: Re: Insert triggers

[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
triggers associated with any inserts, updates, or deletes that are
done by a trigger.


Ah, I see now I have confused cascading triggers and recursive triggers. 
The former are supported, the latter are not. That is, an action in a 
trigger may fire another trigger, but not the same trigger that is 
currently running.


Sorry for misinformation.

Igor Tandetnik