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

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.

Re: [sqlite] SQLite + unicode

2011-08-20 Thread Kees Nuyt
On Sat, 20 Aug 2011 01:45:42 -0700 (PDT), NOCaut per...@mail.ru 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

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,

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.

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

[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.

Re: [sqlite] SQLite + unicode

2011-08-19 Thread Kees Nuyt
On Fri, 19 Aug 2011 08:26:49 -0700 (PDT), NOCaut per...@mail.ru 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 =

Re: [sqlite] SQLite + unicode

2011-08-19 Thread Stephan Beal
On Fri, Aug 19, 2011 at 5:46 PM, Kees Nuyt k.n...@zonnet.nl 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...

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, /*

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

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.

Re: [sqlite] SQLite + unicode

2011-08-11 Thread Igor Tandetnik
NOCaut per...@mail.ru 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 */

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.

Re: [sqlite] SQLite + unicode

2011-08-11 Thread Igor Tandetnik
NOCaut per...@mail.ru 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 ___

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

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

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] 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

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

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

Re: [sqlite] SQLite + unicode

2011-08-10 Thread Stephan Beal
On Wed, Aug 10, 2011 at 5:55 PM, NOCaut per...@mail.ru 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

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

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

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:

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

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

[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