Re: [sqlite] Build instructions for Winodws with unicode support

2011-04-05 Thread tiwaris
Thanks for the help. I finally resolved the problem. The compile flags that I was using on Windows were the culprit. The following set of commands correctly build the sqlite library (build environment is Microsoft Platform SDK v6.1). cl.exe /O2 /GL /D "WIN32" /D "_WINDLL" /D "_UNICODE" /D "UNICO

Re: [sqlite] Build instructions for Winodws with unicode support

2011-04-04 Thread Pavel Ivanov
> Basically, the column with name "model" has data type BLOB, and null is > being written to that column. I think your problem is with jdbc driver (I guess its setBytes implemented via the text data type, not blob) and with the fact that writeBuffer[0] is equal to 0. Changing writeBuffer[0] to som

Re: [sqlite] Build instructions for Winodws with unicode support

2011-04-04 Thread tiwaris
Hello, I created the following sample code to test the BLOB data type. I am using sqlite-jdbc driver provided at (http://www.xerial.org/trac/Xerial/wiki/SQLiteJDBC). The following is the source code (SSCE). package org.sqlite; import java.sql.Connection; import java.sql.DriverManager; import

Re: [sqlite] Build instructions for Winodws with unicode support

2011-04-04 Thread Pavel Ivanov
> I can create the dll, but it does not work with BLOB data type. It works > with other data types. The dll that I downloaded from the sqlite.org website > works with BLOB data type. > > Any help would be appreciated. Any pointers on what doesn't work for you and how it works instead of intended b

[sqlite] Build instructions for Winodws with unicode support

2011-04-04 Thread tiwaris
Hello, I need build instructions for Windows with unicode support. I am using sqlite3.h and sqlite3.c from the amalgamation source downloaded from http://sqlite.org/sqlite-amalgamation-3070500.zip. I am using the following CFLAGS when compiling sqlite SQLITE_ENABLE_COLUMN_METADATA SQLITE_ENABL