Re: [sqlite] SQLite + unicode

2011-08-21 Thread NOCaut 

Thanks i change 1251 to CP_UTF8 All work :jumping:
-- 
View this message in context: 
http://old.nabble.com/SQLite-%2B-unicode-tp32296232p32301685.html
Sent from the SQLite mailing list archive at Nabble.com.

___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] SQLite + unicode

2011-08-20 Thread Jean-Christophe Deschamps 

>I try this function. Do you have Visual Studio. i show you my example.
>
>NOCaut wrote:
> >
> >
> > char * unicode_to_1251(wchar_t *unicode_string)

Why are you converting Unicode to 1251?  This is a lossy conversion in 
the general case.

Work with Unicode strings end-to-end, using the UTF encoding of your 
choice.  Since you're using Windows, UTF16-LE is the natural choice but 
you can still use UTF-8 as well of course.

Note that this is for SQLite API interface only.  Internally, SQLite 
will store text under the UTF setting which was used when creating the 
DB.  By default, SQLite will create an UTF-8 DB but you can force 
UTF-16 _storage_ at creation time.

After that you can use either the UTF-8 API functions or the UTF-16 
versions and SQLite will perform the necessary conversion internally 
for you.

At your application level, you probably want to use UTF16-LE (Windows) 
but you may have to convert external ANSI data sources (if any) like 
.CSV files or such  into Unicode for DB storage.

--
j...@antichoc.net  

___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] SQLite + unicode

2011-08-20 Thread NOCaut 

this is my example spellings on the VS2008
http://www.4shared.com/file/RDzSVPZq/SQLite_example.html

-- 
View this message in context: 
http://old.nabble.com/SQLite-%2B-unicode-tp32296232p32301433.html
Sent from the SQLite mailing list archive at Nabble.com.

___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] SQLite + unicode

2011-08-20 Thread NOCaut 

I try this function. Do you have Visual Studio. i show you my example.

NOCaut wrote:
> 
> 
> char * unicode_to_1251(wchar_t *unicode_string)
> {
>   int err;
>   char * res;
>   int res_len = WideCharToMultiByte(
>   1251,   // Code page
>   0,  // Default replacement 
> of illegal chars
>   unicode_string, // Multibyte characters string
>   -1, // Number of unicode 
> chars is not known
>   NULL,   // No buffer yet, allocate it 
> later
>   0,  // No buffer
>   NULL,   // Use system default
>   NULL// We are not interested 
> whether the default char was used
>   );
>   if (res_len == 0) 
>   {
>   printf("Failed to obtain required cp1251 string length\n");
>   return NULL;
>   }
>   res = (char*)calloc(sizeof(char), res_len);
>   if (res == NULL) 
>   {
>   printf("Failed to allocate cp1251 string\n");
>   return NULL;
>   }
>   err = WideCharToMultiByte(
>   1251,   // Code page
>   0,  // Default replacement 
> of illegal chars
>   unicode_string, // Multibyte characters string
>   -1, // Number of unicode 
> chars is not known
>   res,// Output buffer
>   res_len,// buffer size
>   NULL,   // Use system default
>   NULL// We are not interested 
> whether the default char was used
>   );
>   if (err == 0)
>   {
>   printf("Failed to convert from unicode\n");
>   free(res);
>   return NULL;
>   }
>   return res;
> }
> 

-- 
View this message in context: 
http://old.nabble.com/SQLite-%2B-unicode-tp32296232p32301058.html
Sent from the SQLite mailing list archive at Nabble.com.

___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] SQLite + unicode

2011-08-20 Thread Kees Nuyt 
On Sat, 20 Aug 2011 01:45:42 -0700 (PDT), NOCaut 
wrote:

> For "" and '' i know thanks, and why you write ?
> i want write arabic symbul 

Apparently your utf-8 Arabic characters were dropped and replaced
by ?, probably by my mail reader. My apologies.

Replace the '?' by the utf-8 you originally used in your
program.
-- 
  (  Kees Nuyt
  )
c[_]
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] SQLite + unicode

2011-08-20 Thread NOCaut 

For "" and '' i know thanks, and why you write ? i want write arabic
symbul مثالمثالمثالمثال
-- 
View this message in context: 
http://old.nabble.com/SQLite-%2B-unicode-tp32296232p32300446.html
Sent from the SQLite mailing list archive at Nabble.com.

___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] SQLite + unicode

2011-08-19 Thread Stephan Beal 
On Fri, Aug 19, 2011 at 5:46 PM, Kees Nuyt  wrote:

> Also of interest might be:
> http://www.sqlite.org/cvstrac/wiki?p=SqliteWrappers


i've got a link addition for the JavaScript bindings, if anyone with wiki
commit access is listening...

http://code.google.com/p/v8-juice/wiki/JSPDO

JSPDO is a PHP PDO-like db access abstraction layer for the Google v8 JS
engine.

The SpiderApe link at the top of the JS list is no longer maintained (it's
mine, so i can vouch for it ;), so it can probably be removed (but SpiderApe
had  the first JS bindings i'm aware of for sqlite3, so maybe it has a byte
or two of historical value ;).

And for C/C++ wrappers:

http://fossil.wanderinghorse.net/repos/cpdo/

cpdo is a PDO-like db access abstraction layer for C. Includes a C++ wrapper
API.


Happy Hacking!

-- 
- stephan beal
http://wanderinghorse.net/home/stephan/
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] SQLite + unicode

2011-08-19 Thread Kees Nuyt 

On Fri, 19 Aug 2011 08:26:49 -0700 (PDT), NOCaut 
wrote:

> Say my some wrapper for i can make this query:
> "Select Value from Config
> Where Key = \"??\""

In SQL, string literals are delimited by single qoutes.
So, the statement would be:

SELECT Value FROM Config WHERE Key = '??';

Single quotes inside a string can be escaped with another single
quote. 'O'Donnell' -> 'O''Donnell'.
Of course, escaping is not needed when you sqlite3_bind*() the
values using the C programming interface.

Your question is not completely clear to me, so here are a few
pointers.

You can find some coding examples in the wiki:

http://www.sqlite.org/cvstrac/wiki?p=SampleCode

http://www.sqlite.org/cvstrac/wiki?p=SimpleCode

Also of interest might be:
http://www.sqlite.org/cvstrac/wiki?p=SqliteWrappers

Lots of links to follow from there.

Good luck.
-- 
  (  Kees Nuyt
  )
c[_]
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

[sqlite] SQLite + unicode

2011-08-19 Thread NOCaut 

Say my some wrapper for i can make this query: "Select Value from Config
Where Key = \"بوبوبو\""

Thanks.
-- 
View this message in context: 
http://old.nabble.com/SQLite-%2B-unicode-tp32296232p32296232.html
Sent from the SQLite mailing list archive at Nabble.com.

___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] SQLite + unicode

2011-08-11 Thread NOCaut 

It`s so hard for me.  I'll be very grateful :jumping: 
-- 
View this message in context: 
http://old.nabble.com/SQLite-%2B-unicode-tp32235242p32243061.html
Sent from the SQLite mailing list archive at Nabble.com.

___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] SQLite + unicode

2011-08-11 Thread NOCaut 

please kill me %-|
-- 
View this message in context: 
http://old.nabble.com/SQLite-%2B-unicode-tp32235242p32242440.html
Sent from the SQLite mailing list archive at Nabble.com.

___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] SQLite + unicode

2011-08-11 Thread Pavel Ivanov 
> Don't use sqlite3_exec. Use sqlite3_prepare16 (which accepts wchar_t*), 
> sqlite3_step, sqlite3_finalize. Read text from columns with 
> sqlite3_column_text16 (which returns wchar_t*).

I'd say it's not exactly this way. AFAIK, wchar_t on Linux is
32-bit, but sqlite3_column_text16 will return 16-bit characters. And
that will be UTF-16 string. For OP it will make any difference only if
he wants to feed the received string to some function accepting real
wchar_t*. Some conversion will be necessary.


Pavel


On Thu, Aug 11, 2011 at 8:04 AM, Igor Tandetnik  wrote:
> NOCaut  wrote:
>> I now how work with sqlite guys
>>
>> my problem: in  const char *  and i wont wchar_t*. becouse wchar_t* -
>> unicode type understand
>>
>> int sqlite3_exec(
>>  sqlite3*,                     /* An open database */
>>  const char *sql,              /* SQL to be executed */
>>  sqlite3_callback,             /* Callback function */
>>  void *,                       /* 1st argument to callback function */
>>  char **errmsg                 /* Error msg written here */
>> );
>
> Don't use sqlite3_exec. Use sqlite3_prepare16 (which accepts wchar_t*), 
> sqlite3_step, sqlite3_finalize. Read text from columns with 
> sqlite3_column_text16 (which returns wchar_t*).
> --
> Igor Tandetnik
>
> ___
> sqlite-users mailing list
> sqlite-users@sqlite.org
> http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
>
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] SQLite + unicode

2011-08-11 Thread Igor Tandetnik 
NOCaut  wrote:
> I want use but sqlity3.h NOT have this function.

Does not have which function? The one you can download from 
http://sqlite.org/download.html certainly declares all the functions I've 
mentioned.
-- 
Igor Tandetnik

___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] SQLite + unicode

2011-08-11 Thread NOCaut 

I want use but sqlity3.h NOT have this function.
and i create this post for you help me use this function
-- 
View this message in context: 
http://old.nabble.com/SQLite-%2B-unicode-tp32235242p32241783.html
Sent from the SQLite mailing list archive at Nabble.com.

___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] SQLite + unicode

2011-08-11 Thread Igor Tandetnik 
NOCaut  wrote:
> I now how work with sqlite guys
> 
> my problem: in  const char *  and i wont wchar_t*. becouse wchar_t* -
> unicode type understand
> 
> int sqlite3_exec(
>  sqlite3*, /* An open database */
>  const char *sql,  /* SQL to be executed */
>  sqlite3_callback, /* Callback function */
>  void *,   /* 1st argument to callback function */
>  char **errmsg /* Error msg written here */
> );

Don't use sqlite3_exec. Use sqlite3_prepare16 (which accepts wchar_t*), 
sqlite3_step, sqlite3_finalize. Read text from columns with 
sqlite3_column_text16 (which returns wchar_t*).
-- 
Igor Tandetnik

___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] SQLite + unicode

2011-08-11 Thread NOCaut 

You think i most 
1 -convert to UTF-8
2 -read un the const char * 
3 - convert to anscii 

i right understand you?

-- 
View this message in context: 
http://old.nabble.com/SQLite-%2B-unicode-tp32235242p32241427.html
Sent from the SQLite mailing list archive at Nabble.com.

___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] SQLite + unicode

2011-08-11 Thread Teg 
Hello NOCaut,

I convert everything to UTF-8 for insert and then back to ascii or
unicode when I pull the data from the DB.

C

Thursday, August 11, 2011, 4:20:36 AM, you wrote:

N> I now how work with sqlite guys

N> my problem: in  const char *  and i wont wchar_t*. becouse wchar_t* -
N> unicode type understand

N>  int sqlite3_exec(
N>   sqlite3*, /* An open database */
N>   const char *sql,  /* SQL to be executed */
N>   sqlite3_callback, /* Callback function */
N>   void *,   /* 1st argument to callback function */
N>   char **errmsg /* Error msg written here */
N> );

N>sqlite3 *db;
N> char *zErrMsg = 0;
N> int rc;
N> rc = sqlite3_open("c:\\test.db", );
N> 
N> rc = sqlite3_exec(db, "Select * from table ", callback, 0, );

N> this code return char I want use wchar_t* for read unicode.

N> Thanks!




-- 
Best regards,
 Tegmailto:t...@djii.com

___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] SQLite + unicode

2011-08-11 Thread NOCaut 

I now how work with sqlite guys

my problem: in  const char *  and i wont wchar_t*. becouse wchar_t* -
unicode type understand

 int sqlite3_exec(
  sqlite3*, /* An open database */
  const char *sql,  /* SQL to be executed */
  sqlite3_callback, /* Callback function */
  void *,   /* 1st argument to callback function */
  char **errmsg /* Error msg written here */
);

   sqlite3 *db;
char *zErrMsg = 0;
int rc;
rc = sqlite3_open("c:\\test.db", );

rc = sqlite3_exec(db, "Select * from table ", callback, 0, );

this code return char I want use wchar_t* for read unicode.

Thanks!

-- 
View this message in context: 
http://old.nabble.com/SQLite-%2B-unicode-tp32235242p32240215.html
Sent from the SQLite mailing list archive at Nabble.com.

___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] SQLite + unicode

2011-08-10 Thread Igor Tandetnik 
On 8/10/2011 12:39 PM, NOCaut wrote:
> I work in VS2008 c++
> i create data base my.db and wont use U N I C O D E function from this DLL

Why won't you?

Which DLL is 'this DLL'?

> i find class or unit for connect to my base from VS2008
> http://sqlite.org/download.html - this link help me?

I imagine it should. You might also fine these useful: the API reference

http://sqlite.org/c3ref/funclist.html

And a very simple sample:

http://sqlite.org/quickstart.html

> you understand me?

No, I don't think I do, I must admit.
-- 
Igor Tandetnik

___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] SQLite + unicode

2011-08-10 Thread Doug Currie 

On Aug 10, 2011, at 12:39 PM, NOCaut wrote:

> I work in VS2008 c++ 
> i create data base my.db and wont use U N I C O D E function from this DLL 
> i find class or unit for connect to my base from VS2008
> http://sqlite.org/download.html - this link help me?
> 
> you understand me?

No, but maybe these links will help...

http://www.sqlite.org/faq.html#q18

http://old.nabble.com/enable-ICU-in-SQLite-on-windows-platform-td27371403.html

http://www.urban-eye.com/pagesqliteicu.html

http://site.icu-project.org/

e

___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] SQLite + unicode

2011-08-10 Thread NOCaut 

I work in VS2008 c++ 
i create data base my.db and wont use U N I C O D E function from this DLL 
i find class or unit for connect to my base from VS2008
http://sqlite.org/download.html - this link help me?

you understand me?
-- 
View this message in context: 
http://old.nabble.com/SQLite-%2B-unicode-tp32235242p32235681.html
Sent from the SQLite mailing list archive at Nabble.com.

___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] SQLite + unicode

2011-08-10 Thread Igor Tandetnik 
On 8/10/2011 12:08 PM, NOCaut wrote:
> in the other forum say: "You can get the SQLite source code and compile it
> directly with C++ Builder (2010 and XE tested)."

If you need SQLite source code, it's here: 
http://sqlite.org/download.html . See also 
http://sqlite.org/amalgamation.html
-- 
Igor Tandetnik

___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] SQLite + unicode

2011-08-10 Thread NOCaut 

in the other forum say: "You can get the SQLite source code and compile it
directly with C++ Builder (2010 and XE tested)." 

Come to home and see
-- 
View this message in context: 
http://old.nabble.com/SQLite-%2B-unicode-tp32235242p32235384.html
Sent from the SQLite mailing list archive at Nabble.com.

___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] SQLite + unicode

2011-08-10 Thread Stephan Beal 
On Wed, Aug 10, 2011 at 5:55 PM, NOCaut  wrote:

> Where i can find c++ unicode unit for work with SQLite database? Thanks.
>

If you're looking for a generic unicode C++ library i can highly recommend:

http://utfcpp.sourceforge.net/

it's easy to use, header-only, and liberally licensed.

-- 
- stephan beal
http://wanderinghorse.net/home/stephan/
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] SQLite + unicode

2011-08-10 Thread NOCaut 

Sorry for my bad english)) I want find source code for work with sqlite..
-- 
View this message in context: 
http://old.nabble.com/SQLite-%2B-unicode-tp32235242p32235334.html
Sent from the SQLite mailing list archive at Nabble.com.

___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] SQLite + unicode

2011-08-10 Thread Igor Tandetnik 
On 8/10/2011 11:55 AM, NOCaut wrote:
> Where i can find c++ unicode unit for work with SQLite database? Thanks.

What kind of "unit"? What is it that you want to do, but cannot, without 
such a "unit"?
-- 
Igor Tandetnik

___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

[sqlite] SQLite + unicode

2011-08-10 Thread NOCaut 


Where i can find c++ unicode unit for work with SQLite database? Thanks.
-- 
View this message in context: 
http://old.nabble.com/SQLite-%2B-unicode-tp32235242p32235242.html
Sent from the SQLite mailing list archive at Nabble.com.

___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

[sqlite] SQLite unicode problems

2005-09-26 Thread Alexander J. Kozlovsky 
Hello, SQLite developers!

Sorry for my bad English.

I use SQLite (great program!), and encounter some unicode problems.
I think, this problems not with dbms kernel, but with command-line
utilite.

So far as SQLite supports unicode, I want at least enter russian
strings into table rows and (probably) create tables and columns
with russian names. I use SQLite from Python via PySQLite 2.0.4
(SQLite version 3.2.5), and it works without any problem -- I can
create russian strings and russian-named tables.

But when I open database with command-line utilite (SQLite version
3.2.6, Windows 2000), I see unreadable junk instead of russian symbols.

Interestingly, I can create create database in command-line utilite,
enter russian strings and create tables with russian names, and all
works without any visible errors (such as 'incorrect symbols in table
name'), but database contains string in native 'cp866' encoding
instead of utf-8. When I try open this file from Python via PySQLite,
I get UnicodeDecodeError.

( There are two russian 8-bit encodings in Windows. Most programs
  store data in 'cp1251' (also known as 'Windows-1251') encoding.
  But command prompt window uses legacy 'cp866' encoding )

It seems today's sqlite command-line utilite completely unaware
about non-ascii symbols and always keep this in current encoding
instead of unicode.

Attached file 'db1' is correct database file created via PySQLite.
All russian strings properly encoded as utf-8. It won't work with
command-line utilite (all russian strings printed as unreadable junk).

Attached file 'db2' is incorrect database with same structure created
via command-line utilite. All russian strings erroneously encoded
as cp866. It printed perfectly in command line, but won't work with
PySQLite (UnicodeDecodeError raised when I try execute query).

I think, command-line utilite must determine current encoding
(In my case, cp866), and perform transformation
native_encoding <-> utf-8.

-

Attached text files is SQL scripts containing russian symbols in
different encodings. I try execute this files in command-line utilite.
This files have same content, but in different encodings.

'cp866.txt' generates incorrect database which worked as "normal" from
command-line utilite, but keep non-ascii strings as cp866 instead of unicode.

'cp1251.txt' is usual russian text in Windows. Almost all programs
generates russian text in this encoding. When i try read this file
from command-line utilite, result database contains cp1251-encoded
strings instead of unicode. Screen output is unreadable in command
line, and database not work in Python ('UnicodeDecodeError' raises)

Main russian encoding in Windows is cp1251. I think, ideal solution
for russian strings is read and write dump files as cp1251, but produce
screen output as cp866. As minimal solution, all data and files can be
procesed as cp866, with internal converting to utf-8.

'utf8-bom.txt' is unicode file, created with standard Windows text
editor (Notepad). On Windows, all generated utf-8 files have prefix
0xEF 0xBB 0xBF (this utf-8 'byte order mark' used for distinguish
from plain 8-bit text). sqlite.exe generates error when read this file.

'utf8.txt' is the same file as 'utf8-bom.txt' with header deleted
manually (Standard windows editors don't allow delete this header).
It works well, and generated correct database. Printed russian strings
unreadable from sqlite command-line utilite.

'utf16be.txt' and 'utf16le.txt' are SQL scripts in 16-bit Unicode
format (Big-Endian and Low-Endian correspondingly). Todays
sqlite command-line utilite can't read this files.

-

I think, ideal command line utilite must read correctly ALL these
files except 'cp866.txt', and keep strings as unicode.
Russian screen output on Windows must be generated in cp866.


Best regards,
 Alexander  mailto:[EMAIL PROTECTED]BEGIN TRANSACTION;
CREATE TABLE t1 (a integer, b text);
INSERT INTO t1 VALUES(1, 'English');
INSERT INTO t1 VALUES(2, 'ãá᪨©');
CREATE TABLE ’ ¡«¨æ  (Š®«®­ª 1, Š®«®­ª 2);
INSERT INTO ’ ¡«¨æ  VALUES('‘âப 1', '‘âப 2');
COMMIT;
BEGIN TRANSACTION;
CREATE TABLE t1 (a integer, b text);
INSERT INTO t1 VALUES(1, 'English');
INSERT INTO t1 VALUES(2, 'Ðóññêèé');
CREATE TABLE Òàáëèöà (Êîëîíêà1, Êîëîíêà2);
INSERT INTO Òàáëèöà VALUES('Ñòðîêà1', 'Ñòðîêà2');
COMMIT;
BEGIN TRANSACTION;
CREATE TABLE t1 (a integer, b text);
INSERT INTO t1 VALUES(1, 'English');
INSERT INTO t1 VALUES(2, 'Русский');
CREATE TABLE Таблица (Колонка1, Колонка2);
INSERT INTO Таблица VALUES('Строка1', 'Строка2');
COMMIT;
BEGIN TRANSACTION;
CREATE TABLE t1 (a integer, b text);
INSERT INTO t1 VALUES(1, 'English');
INSERT INTO t1 VALUES(2, 'Русский');
CREATE TABLE Таблица (Колонка1, Колонка2);
INSERT INTO Таблица