[sqlite] Encoding confusion

Hi! I am using SQLITE to save webbased data, under Unix, linux, osx the program is written i C, and uses the C-interface. What is confusing me is how are the string stored, if i understand corrent it is UTF-8 is this done automatic and what coding is a get back when a extra data ? Stupid questio

Re: [sqlite] Charset-Confusions

I use sqlitebrowser and is very happy with it http://sqlitebrowser.sourceforge.net mvh Anders COS skrev: Anne, - Original Message - From: <[EMAIL PROTECTED]> To: Sent: Monday, May 15, 2006 3:44 PM Subject: [sqlite] Charset-Confusions An the 2. question: Is there any Really-Goo

Re: [sqlite] Compiling Sqlite JDBC driver (Compiler question)

I don't know if this helps but when i was building a static version for Windows 1. maked a static dll project and added all files but NOT precompiled WIndows stufff.. If i added use precompiled windowsfile it never compiled.. // Anders [EMAIL PROTECTED] skrev: Hello, I hope this isn't too o

Re: [sqlite] How can I get the type of a column?

1. Open the required database. 2. Run the sqlquestion select * from sqlite_master; you get a declaration of table,namn and types. // Anders sqlite skrev: Roger Binns wrote: The types point still baffles me. If your code already knows which column it is dealing with then surely the code s

Re: [sqlite] Creating a database

To be more clearer the OPEN commad makes a database if it is missing // Anders Anders Persson skrev: I am using the C api and here a database i created if it dosen't exist. // Anders John Newby skrev: Hi, I know how to create a databse from a DOS prompt by going to the directory the .exe

Re: [sqlite] Creating a database

I am using the C api and here a database i created if it dosen't exist. // Anders John Newby skrev: Hi, I know how to create a databse from a DOS prompt by going to the directory the .exe file is and by typing sqlite3 name.db which then creates the database, but what I do not know is how to crea

[sqlite] C API Question

I have written a wrapper around iRes = sqlite3_get_table(db,sql,&resultp,&nrow,&ncolumn,&errmsg); But only SELECT works not INSERT or UPDATE any ide.. missing somting // Anders

[sqlite] Lost in Windows

I have build sqlite for diffrent Unixversion but, when a come to Windows i am lost i have 1. sqlite3.dll 2. sqlite3.exe 3. sqlite3.h VisualStudio C 6.0 and supose to use commands as cl .. somting I don't have a clue how to talk with the dll some !!! // Anders

Re: [sqlite] Vacuum Command

I testad on sqlite and sorry you was corrent i got en error messages. // Anders George Mavroudes skrev: I was with the impression that you cannot call VACUUM from within a Transaction. I conclude this by reading the code. Will this work? GM -Original Message- From: Anders

Re: [sqlite] Vacuum Command

I am new to SQLITE but in some other database vacuum want to have full controll test with Transaction as BEGIN EXCLUSIVE TRANSACTION test VACUUM [tableName] END TRANSACTION test // Anders George Mavroudes skrev: Sorry for the omission and thanks for the quick response. -We are using sqli

Re: [sqlite] where can i find the file "sqlite.h"

skrev: Hi Anders, But I cannot find "sqlite3.h" in all sqlite downloads either. Is there any way to generate this file. Thanks Min 2006/5/2, Anders Persson <[EMAIL PROTECTED]>: Min Shi skrev: > Hi all, > Where can i find the file "sqlite.h" for coding on wi

Re: [sqlite] where can i find the file "sqlite.h"

Min Shi skrev: Hi all, Where can i find the file "sqlite.h" for coding on windows platform? Thank you for your suggestions. Min is is called sqlite3.h // Anders

Re: [sqlite] Build static under Solaris

Phuah Yee Keat skrev: Anders Persson wrote: i try to compile it with gcc --static -I../sqlite -L../sqlite/.libs -o db-test db-test.c -lsqlite3 But i get errors like Undefined first referenced symbol in file fdatasync

[sqlite] Build static under Solaris

Hi! I am using sqlite-3.3.5.tar.gz My problems is that i want to build a sqlite programs that use static library and custom directorystructure. The reason for this is that i will build to software for other platforms and for mantains would like to ha