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 UNICODE /MD
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
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
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
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
