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@s

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 encod

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

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 '?'

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

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 = '??'; Sin

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

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

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

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 mail

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

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

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 ima

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

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

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

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 mail

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 sql

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

[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 (probab