RE: [sqlite] problems compiling 3.2.6
Or download the CVS version, it has already been fixed by drh in there! -Oorspronkelijk bericht- Van: Maurizio Ferraris [mailto:[EMAIL PROTECTED] Verzonden: dinsdag 20 september 2005 15:13 Aan: sqlite-users@sqlite.org Onderwerp: Re: [sqlite] problems compiling 3.2.6 I also have the same problems with VC6, and unfortunately I cannot switch to VC7 for other reasons. At the moment I reverted back to 3.2.5. When I will have some spare time I will try to fix it myself and I will inform the list. My guess is: update too the latest SDK (that unfortunately does not integrate well with VC6) for the first problem and add another (__int64) cast before the conversion to double. Of course this is just a hack and I hope someone will find a better fix. Regards. Mau. Drew, Stephen wrote: > Further update: > > I get both these errors in Visual Studio 6. > > As you say, I think the first is just that Visual Studio 6 has a missing > definition in winbase.h. I agree with you that it is in the > documentation (perhaps a check could be performed and it defined if it > doesn't exist...) > > The second seems to be a limitation of VS6 - it certainly isn't a > problem in VS7. Can't really think of any neat solution around it > either... > > This doesn't concern me, as - as I mention - I use VS7... > > Steve > > -Original Message- > From: Drew, Stephen > Sent: 19 September 2005 17:13 > To: sqlite-users@sqlite.org > Subject: RE: [sqlite] problems compiling 3.2.6 > > Mike, > > 3.2.6 compiles fine in Visual Studio 7 (.NET 2003). I can give it a go > in my copy of Visual Studio 6 if you like... > > Steve > > -Original Message- > From: Cariotoglou Mike [mailto:[EMAIL PROTECTED] > Sent: 19 September 2005 10:14 > To: sqlite-users@sqlite.org > Subject: [sqlite] problems compiling 3.2.6 > > I tried to compile 3.2.6 locally, using visual c 6, as I do with all > sqlite releases. this version introduces a couple of changes that do not > compile: > > os_win.c(482) : error C2065: 'INVALID_SET_FILE_POINTER' : undeclared > identifier > vdbeapi.c(237) : error C2520: conversion from unsigned __int64 to double > not implemented, use signed __int64 > > the first error has to do with an old version of winbase.h, which for > some reason omits the definition of INVALID_SET_FILE_POINTER (although > the documentation mentions it). this is probably a local problem, and I > will try to fix locally (although I would like to hear from other people > about it. I am compiling WITHOUT mfc). > > the second I have no idea, as I don't know C. > > anybody help ? > > > > > > > > > >
[sqlite] Speed.html
Hi, I just redid the speedtest.tcl-script in PHP (http://www.karels0ft.be/tmp/speed_script.html). Can anyone check why the SQLite3's are so slow compared to SQLite2's ? This script maybe could be used by someone with too much time to check up the timings of the latest versions, to recreate the speed.html-document, as it's a little outdated. [http://www.karels0ft.be/tmp/speed.html] Reactions would be nice too :) Greetings, Steven
[sqlite] BEGIN; - clausule
Hi, When I was using 2.8, i could do the following: BEGIN ON CONFLICT IGNORE; As of v3 it seems this is gone? Is there any way to achieve the same, but not to add it to EVERY query in the transaction? Thanks, Steven
Re: [sqlite] Clearing of memory
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 Mime-Version: 1.0 Content-Type: multipart/mixed; x-avg-checked=avg-ok-786B32B5; boundary="===733C1D2===" - --===733C1D2=== Content-Type: multipart/alternative; x-avg-checked=avg-ok-786B32B5; boundary="=_30639234==.ALT" - --=_30639234==.ALT Content-Type: text/plain; x-avg-checked=avg-ok-786B32B5; charset=us-ascii; format=flowed Content-Transfer-Encoding: 8bit You are right... I changed the code to "return true" always ;) Thanks for the tip :) At 13:43 3/12/2004, you wrote: >You are making a bad assumption. sqlite3_finalize() clears >the memory regardless of what return code you get. KaReL (aka Steven) Main Webpage : http://www.karels0ft.be/ ICQ #: 35217584 - --=_30639234==.ALT Content-Type: text/html; x-avg-checked=avg-ok-786B32B5; charset=us-ascii Content-Transfer-Encoding: 8bit You are right... I changed the code to return true always ;) Thanks for the tip :) At 13:43 3/12/2004, you wrote: You are making a bad assumption. sqlite3_finalize() clears the memory regardless of what return code you get. KaReL (aka Steven) Main Webpage : http://www.karels0ft.be/; eudora="autourl">http://www.karels0ft.be/ ICQ # : 35217584 - --=_30639234==.ALT-- - --===733C1D2===-- -BEGIN PGP SIGNATURE- Version: PGP 8.0.3 iQA/AwUBQbBjO8pHmxag5XckEQKC7QCg8Kt1ou0AdSHuV1CUt8e0sUOrFdkAoLWM 6cJso/ex0wwnv0AVIOJLlKBC =cId6 -END PGP SIGNATURE-
Re: [sqlite] Clearing of memory
That's what I thought... int r = sqlite3_finalize(m_Stmt); if ( r != SQLITE_OK ) { m_szErrorMsg = wxString(sqlite3_errmsg(m_DB), wxConvUTF8); return false; } The error I got is: "cannot start a transaction within a transaction" (cfr previous mail). Thus the memory ain't cleared... Probably I'm doing something wrong with the query, but that doesn't mean I cannot clear the memory right? Cheers, Steven At 13:01 3/12/2004, you wrote: Steven Van Ingelgem wrote: Hi, Another question that arises is ... How do I clear my memory... Call sqlite3_finalize() on every pointer you got from sqlite3_prepare(). Then call sqlite3_close(). -- D. Richard Hipp -- [EMAIL PROTECTED] -- 704.948.4565 KaReL (aka Steven) Main Webpage : http://www.karels0ft.be/ ICQ # : 35217584 pgp2sycU3bCmW.pgp Description: PGP signature
Re: [sqlite] TRANSACTION-question
Hmmm, it doesn't work... It still doesn't write to the database. When I do everything without a transaction, it is written correctly, but I don't want it because I first empty the whole table. Now if the pc crashes, everything is lost. And that's not what I want... So only when the complete transaction is finished I want it to continue. At 10:26 3/12/2004, you wrote: Yes, you do it. Bye - Original Message - From: Steven Van Ingelgem To: [EMAIL PROTECTED] Sent: Friday, December 03, 2004 10:02 AM Subject: Re: [sqlite] TRANSACTION-question Do you automatically end a transaction when committing? At 09:11 3/12/2004, you wrote: Hi Steven, I used transactions in C++ code (windows and linux) with sqlite 2.8; try the sequence " BEGIN; DELETE ...; INSERT ...; COMMIT; ", it works in 2.8. Regards Paolo - Original Message - From: Steven Van Ingelgem To: [EMAIL PROTECTED] Sent: Friday, December 03, 2004 8:51 AM Subject: [sqlite] TRANSACTION-question Hi, I do the following (SQLite 308 from C++ source in windows): BEGIN DEFERRED TRANSACTION;DELETE FROM Inbox;INSERT...;COMMIT TRANSACTION; END TRANSACTION; Now, nothing is done? Nothing inserted, nothing deleted from Inbox... Then I tried to execute the same afterwards, but then I got that I am already in a transaction? Is that possible or should I look further? Does a commit end the transaction, or should I end it anyhow? Thx, KaReL (aka Steven) Main Webpage : http://www.karels0ft.be/ ICQ # : 35217584 KaReL (aka Steven) Main Webpage : http://www.karels0ft.be/ ICQ # : 35217584 KaReL (aka Steven) Main Webpage : http://www.karels0ft.be/ ICQ # : 35217584 pgpZbry6ZHQ7y.pgp Description: PGP signature
Re: [sqlite] TRANSACTION-question
Do you automatically end a transaction when committing? At 09:11 3/12/2004, you wrote: Hi Steven, I used transactions in C++ code (windows and linux) with sqlite 2.8; try the sequence " BEGIN; DELETE ...; INSERT ...; COMMIT; ", it works in 2.8. Regards Paolo - Original Message - From: Steven Van Ingelgem To: [EMAIL PROTECTED] Sent: Friday, December 03, 2004 8:51 AM Subject: [sqlite] TRANSACTION-question Hi, I do the following (SQLite 308 from C++ source in windows): BEGIN DEFERRED TRANSACTION;DELETE FROM Inbox;INSERT...;COMMIT TRANSACTION; END TRANSACTION; Now, nothing is done? Nothing inserted, nothing deleted from Inbox... Then I tried to execute the same afterwards, but then I got that I am already in a transaction? Is that possible or should I look further? Does a commit end the transaction, or should I end it anyhow? Thx, KaReL (aka Steven) Main Webpage : http://www.karels0ft.be/ ICQ # : 35217584 KaReL (aka Steven) Main Webpage : http://www.karels0ft.be/ ICQ # : 35217584 pgp28wWEMi9Uy.pgp Description: PGP signature
[sqlite] Clearing of memory
Hi, Another question that arises is ... How do I clear my memory... I try to close a database with a query (transaction: cfr previous mail) prepared & database opened: Is it enough to do "sqlite3_finalize" (which is not when for example you are in a transaction -> memory ain't cleared). Is it enough to do "sqlite3_close" (which is not because you still have open statements) is it ok to use sqlite3_free ( which probably isn't because it works on 'char*' ) When I try to use sqlite3_interrupt on my database I got "library_misuse" Any other options? ;) KaReL (aka Steven) Main Webpage : http://www.karels0ft.be/ ICQ # : 35217584 pgpa6SEkKCUbs.pgp Description: PGP signature
[sqlite] TRANSACTION-question
Hi, I do the following (SQLite 308 from C++ source in windows): BEGIN DEFERRED TRANSACTION;DELETE FROM Inbox;INSERT...;COMMIT TRANSACTION; END TRANSACTION; Now, nothing is done? Nothing inserted, nothing deleted from Inbox... Then I tried to execute the same afterwards, but then I got that I am already in a transaction? Is that possible or should I look further? Does a commit end the transaction, or should I end it anyhow? Thx, KaReL (aka Steven) Main Webpage : http://www.karels0ft.be/ ICQ # : 35217584 pgpCVnosfvaO4.pgp Description: PGP signature
[sqlite] Flush to disc
How can I make sure after an insert that everything has been flushed to disc? I mean, I want even my program to become slower as long as I know everything have been written to disc. At the moment I am using: PRAGMA default_synchronous = FULL; PRAGMA synchronous = FULL; And the queries are all INSERT's without a transaction. Thx, KaReL (aka Steven) Main Webpage : http://www.karels0ft.be/ ICQ # : 35217584 pgpO7DHjniwta.pgp Description: PGP signature
Re: [sqlite] Formatting SQLite-query
Maybe yes. I am currently looking into parameterized queries. Is it like this: sqlite_prepare sqlite_bind_* sqlite_finalize with the query like 'SELECT * FROM ? WHERE ? = ?'... But how can I know what I pass? I mean with %d/%s/... It's rather obvious, but how do I know what I pass when I use those parameters... And this project has been put aside for a while until I find a solution for this problem (it's the only thing keeping me from completing the program :p). But I have still other things to do ;-). Thanks for any help! At 21:35 1/11/2004, you wrote: Steven Van Ingelgem said: > > Sorry but this has already been suggested by "Tiago Dionizio". > > I can use this, but then I have to create some kind of own printf-function > which scans and so on and handles %q's (which is rather dumb in my > opinion, > as SQLite already incorporates it?). > > > I think this is a va_* error but I am unable to determine the exact > source... Your issue then is less with SQLite and more with C++ programming. Your error message might be showing up deep in the SQLite library, but the problem occurs in your handling of the parameters. I would advise you not to let your project get held up on the %Q issue, since the escaping you need to do is pretty trivial. Also consider that SQLite 3 allows you to use parameterized queries, which eliminates the need for the escaping anyway. -- Lazarus Notes from Lazarus Internet Development http://www.lazarusid.com/notes/ Articles, Reviews and Commentary on web development KaReL (aka Steven) Main Webpage : http://www.karels0ft.be/ ICQ # : 35217584 pgp6uvnhC8wCR.pgp Description: PGP signature
Re: [sqlite] Formatting SQLite-query
Sorry but this has already been suggested by "Tiago Dionizio". I can use this, but then I have to create some kind of own printf-function which scans and so on and handles %q's (which is rather dumb in my opinion, as SQLite already incorporates it?). I think this is a va_* error but I am unable to determine the exact source... At 20:07 1/11/2004, you wrote: Steven Van Ingelgem said: > Sorry to bump this up, but i was still not able to find an answer for > this > question :( > > http://www.wxwidgets.org/manuals/2.4.2/wx368.htm#wxstringformat Clay Dowling -- Lazarus Notes from Lazarus Internet Development http://www.lazarusid.com/notes/ Articles, Reviews and Commentary on web development KaReL (aka Steven) Main Webpage : http://www.karels0ft.be/ ICQ # : 35217584 pgpIki8qNIiOM.pgp Description: PGP signature
Re: [sqlite] Formatting SQLite-query
Because wxString::Format doesn't have the '%q' functions which sqlite provides ;-) At 21:30 25/10/2004, you wrote: I assume you are using wxWidgets.. why don't you consider using the specific functions for that purpose included in the wxString class? wxString::Format and wxString::FormatV Tiago On Mon, 25 Oct 2004 20:43:31 +0200, Steven Van Ingelgem <[EMAIL PROTECTED]> wrote: > Hi, > > I wanted to create my own "Format"-thingie, based upon my own database: > > - > Source > - > wxString SQLite3_Db::Format( const wxString& format, ... ) > { > va_list marker; > va_start(marker, format); > > char * t = sqlite3_vmprintf( format.mb_str(wxConvUTF8).data(), marker ); > > va_end(marker); > > wxString retVal( t, wxConvUTF8 ); > > sqlite3_free( t ); > > return retVal; > } > - > > The problem here is that I get very weird results... Now tracing down, I > found that in vxprintf (printf.c) "v = va_arg(ap,int);" is done (my first > argument is %d). > > Now what he gets there is the second parameter! > > > To be more clear: > > SQLite3_Db::Format( "%d%s", 123, "Test" ); > > Then sqlite finds the first %d, tries to get the value of it, but finds the > pointer pointing to 'Test'... > > > > What did I do wrong? > Thx ;) > > > > > KaReL (aka Steven) > > Main Webpage : http://www.karels0ft.be/ > ICQ # : 35217584 > > KaReL (aka Steven) Main Webpage : http://www.karels0ft.be/ ICQ # : 35217584 pgpcrXoXZvKuj.pgp Description: PGP signature
Re: [sqlite] Formatting SQLite-query
I am using Visual C++ 6. And I am using the source-version 3.0.8 of SQLite. So the va_list/end/start... functions should all be the very same... That's why it got me puzzled :S At 22:24 25/10/2004, you wrote: Hi Steve, > Hi, > > I wanted to create my own "Format"-thingie, based upon my own database: [snip] > What did I do wrong? I am not sure, but if the compiler AND the implementation of va_list etc. weren't the same, then all bets are off. This is because va_list etc. are highly implementation-dependent, as the C standard AND the Kernighan & Ritchie book state explicitly. Are you using a precompiled version of SQLite? If so, you need to compile it yourself with the same compiler you are using for your app. If the compiler is the same, does the header file for the va_list etc. implementations come from C++, while the one in SQLite comes from the C library? Then you need to change the C++ code to use the same header file as SQLite. HTH Ulrik Petersen -- Ulrik Petersen, Denmark Emdros -- the text database engine for analyzed or annotated text http://emdros.org/ KaReL (aka Steven) Main Webpage : http://www.karels0ft.be/ ICQ # : 35217584 pgpxKdToRO1oW.pgp Description: PGP signature
[sqlite] Formatting SQLite-query
Hi, I wanted to create my own "Format"-thingie, based upon my own database: - Source - wxString SQLite3_Db::Format( const wxString& format, ... ) { va_list marker; va_start(marker, format); char * t = sqlite3_vmprintf( format.mb_str(wxConvUTF8).data(), marker ); va_end(marker); wxString retVal( t, wxConvUTF8 ); sqlite3_free( t ); return retVal; } - The problem here is that I get very weird results... Now tracing down, I found that in vxprintf (printf.c) "v = va_arg(ap,int);" is done (my first argument is %d). Now what he gets there is the second parameter! To be more clear: SQLite3_Db::Format( "%d%s", 123, "Test" ); Then sqlite finds the first %d, tries to get the value of it, but finds the pointer pointing to 'Test'... What did I do wrong? Thx ;) KaReL (aka Steven) Main Webpage : http://www.karels0ft.be/ ICQ # : 35217584 pgpXI8zwUXOqi.pgp Description: PGP signature
[sqlite] Warnings during compilation
Hi, I just downloaded the sqlite sources (pre-build for windows & 3.0.8). Now during compilation I get this: 0 error(s), 539 warning(s) Is this normal? wxWidgets: CVS_HEAD OS: WindowsXP/1 IDE: MS Visual 6/5 pgppzHFOtJPY2.pgp Description: PGP signature
Re: [sqlite] sqlite.exe binary (windows)
True ... After thinking a while I understood it ;-) Thanks for the explanation. Steven At 16:16 9/09/2004, you wrote: On Thu, 9 Sep 2004, Steven Van Ingelgem wrote: >I just noticed something rather stupid... > >when you .dump a table via the sqlite.exe binary (2.8.15)... It dumps first >the "create table", then the "insert"s, and afterwards the indexes > >Now if you have a very big table it will take a LOT of time to place those >indexes... Maybe it is more performant to place the "create index" just >after the "create table" statement? Try benchmarking it yourself. You'll probably find that it is in fact quicker to insert the data without indexes, and then index. This is because indexing isn't free. It impacts insert and potentially update performance, as the index may also have to be updated with each update, and will certainly need to be updated with each insert. A quick test (374245 rows, single column with index.) With the index created after the inserts: $ cat test.dump.1 | time -p sqlite test.1 real 22.67 user 17.59 sys 1.27 With index created before the inserts: $ cat test.dump.2 | time -p sqlite test.2 real 24.17 user 18.99 sys 1.50 Repeated the test with similar results, so the post-indexing is about 1.5 seconds quicker in this case. > >Greetings, > >KaReL (aka Steven) > Christian -- /"\ \ /ASCII RIBBON CAMPAIGN - AGAINST HTML MAIL X - AGAINST MS ATTACHMENTS / \ pgpue5sOZYMKU.pgp Description: PGP signature
[sqlite] sqlite.exe binary (windows)
I just noticed something rather stupid... when you .dump a table via the sqlite.exe binary (2.8.15)... It dumps first the "create table", then the "insert"s, and afterwards the indexes Now if you have a very big table it will take a LOT of time to place those indexes... Maybe it is more performant to place the "create index" just after the "create table" statement? Greetings, KaReL (aka Steven) Main Webpage : http://www.karels0ft.be/ ICQ # : 35217584 pgpYvvAFbblCO.pgp Description: PGP signature
Re: [sqlite] Upgrading SQLite versions
Very weird... I thought so they would be compatible. But when I delete the old database and restart the program it works fine... (recreation of a new database with the new version)... Nothing else has changed except the sqlite-version (2.8.13->2.8.15). I work with UTF8 1 and ISO8991 0 (or something like that). The two ways I have tried it are: 1/ same box, same program, 2 accounts (via winxp fast user switching)... The 1st one opens the program, the second one opens the program and tries to insert a new adress. No constant polling of the database is done etc?? 2/ 2 computers, common share on windows server... 1 person opens the program on 1 client, 2nd person on 2nd client, 2nd tries to insert an adress... Both setups give 'database is locked'. :S Sorry for the long delay (no internet for 4 days -> arrgh). At 10:15 20/08/2004, you wrote: Steven Van Ingelgem wrote: Hi, 1/ I am currently using 2.8.13 and I wanted to upgrade it to 2.8.15... Now when I do that, my program crashes when I try to open (sqlite_open) the database on the following function: rc = sqliteBtreeFactory(db, zFilename, 0, MAX_PAGES, >aDb[0].pBt); Is that "normal" behaviour (for instance: no binary compatibilities between 2.8.x versions?). Of course that would be better then to immediatly upgrade to 3.0 if i have to convert all the databases ofcourse. But then the same question stays... Is there compatibility between those versions? (again I mean: just update the source & I can still work on the same databases without doing something special). 2/ I use wxSQLite to access databases. When 1 person has my program open (just open, that means not doing anything). Then another person opens a program from a different location, and access the same databases. He can read it without a problem, but he can't do any insert/update/delete ? (so I think he can acquire readlock, but no writelock). [using 2.8.13]. Is this a feature or a bug? (as far as I understood, sqlite locks the database file when it is needed, but not all the time?). Could someone answer those questions, I would be very gratefull. BTW, if I am unclear somewhere, please request more information! Thx, KaReL (aka Steven) *Main Webpage* : http://www.karels0ft.be/ *ICQ #* : 35217584Sqlite minor versions should have compatible database formats, so if you're having crashes, there's probably a problem somewhere else. For the other question, how are the two people accessing the database file? NFS, samba, or just different terminals on the same box? This can make a difference, as locking on network filesystems has varying levels of success(although it is never reccomended). John LeSueur KaReL (aka Steven) Main Webpage : http://www.karels0ft.be/ ICQ # : 35217584
[sqlite] Upgrading SQLite versions
Hi, 1/ I am currently using 2.8.13 and I wanted to upgrade it to 2.8.15... Now when I do that, my program crashes when I try to open (sqlite_open) the database on the following function: rc = sqliteBtreeFactory(db, zFilename, 0, MAX_PAGES, >aDb[0].pBt); Is that "normal" behaviour (for instance: no binary compatibilities between 2.8.x versions?). Of course that would be better then to immediatly upgrade to 3.0 if i have to convert all the databases ofcourse. But then the same question stays... Is there compatibility between those versions? (again I mean: just update the source & I can still work on the same databases without doing something special). 2/ I use wxSQLite to access databases. When 1 person has my program open (just open, that means not doing anything). Then another person opens a program from a different location, and access the same databases. He can read it without a problem, but he can't do any insert/update/delete ? (so I think he can acquire readlock, but no writelock). [using 2.8.13]. Is this a feature or a bug? (as far as I understood, sqlite locks the database file when it is needed, but not all the time?). Could someone answer those questions, I would be very gratefull. BTW, if I am unclear somewhere, please request more information! Thx, KaReL (aka Steven) Main Webpage : http://www.karels0ft.be/ ICQ # : 35217584
Re: [sqlite] SQLite for Win32 TCHAR
I understand what he means... I am using SQLite 2.8.11 and I did notice this too... Some Win32 fucntions should have 'A' attached to the end. This way it does not complain when using SQLite embedded in a UNICODE project. [ I even think I submitted a diff with things you would have to change to have absolutely no warnings any more (for a Win32 unicode build that is)] greets... At 06:11 17/03/2004, Andrew Francis wrote: Michael Smith wrote: Has anyone ported the SQLite code to support the Win32 TCHAR type and API? I'll confess I'm not actually sure what you mean by "ported" - do you mean using TCHAR (which is, btw, just a typedef for char or short depending on whether UNICODE is #define'd) in the sqlite library interface, or using TCHAR for Win32 calls? Regardless, I'd start by looking at the sqlite ports to Windows CE / PocketPC. From memory, there are a couple around. Windows CE provides only Unicode versions of the Win32 functions, so generally WinCE code has to be TCHAR/Unicode 'clean.' -- Andrew Francis Software Developer Family Health Software - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] G00fy, (aka KaReL, aka Steven) Main Webpage : http://komma.cjb.net CQ Database : http://lid.fragland.net/ ICQ #: 35217584
[sqlite] Transaction -> OE_Ignore
How do I set a transaction (inserting items) to ignore doubles in keys? As the default behaviour now is to abort/rollback... I've also been looking where the sqlite_vm - structure is defined, but I did not found anything... Is that normal? Or is it just a pointer to a struct with nothing inside? G00fy, (aka KaReL, aka Steven) Main Webpage : http://komma.cjb.net CQ Database : http://lid.fragland.net/ ICQ #: 35217584 MSN : [EMAIL PROTECTED]
[sqlite] Constraint violation on INSERT/UPDATE
I submitted a file to my database, where I just put some unique's on... Now I had a double there somewhere ... And now the whole transmission is not submitted... So I went looking into the sqlite source... And I figured out I should use OE_Ignore (first of all, is that correct if I just want to skip the doubling row?). Second, how do I pass this ignore parameter so the database knows to skip it? Thx ;) G00fy, (aka KaReL, aka Steven) Main Webpage : http://komma.cjb.net CQ Database : http://lid.fragland.net/ ICQ #: 35217584 MSN : [EMAIL PROTECTED]
[sqlite] UTF8 question
If I have a table like: CREATE TABLE routing ( FIELD1 VARCHAR(40) ); what if I get a string which is in ANSI = 40chars, but in UTF8 > 40chars? (for example because it uses ü and such characters...) Does it get stored correctly? G00fy, (aka KaReL, aka Steven) Main Webpage : http://komma.cjb.net CQ Database : http://lid.fragland.net/ ICQ #: 35217584 MSN : [EMAIL PROTECTED]