Incompatibility to sqlite3, cannot properly select

[GoogleCodeExporter]

After creating the database with sqljet I often cannot properly select from the 
created tables, eg.

sqlite> select * from keys where key='HELDIN';
sqlite> select * from keys where key LIKE 'HELDIN';
HELDIN|57125|1

Original issue reported on code.google.com by sto...@gmx.de on 19 Nov 2010 at 1:24

Attachments:

• prepdefr.db.gz

[GoogleCodeExporter]

Please, show some code which creates this database and fills data into it.
Thanks.

Original comment by sergey.s...@gmail.com on 19 Nov 2010 at 1:29

• Changed state: Accepted

[GoogleCodeExporter]

Generally the code is very similar to the attached one, though the attached 
code works very well. I'm still trying to reproduce the error without sending 
the whole application and the data set to you.

Original comment by sto...@gmx.de on 19 Nov 2010 at 2:00

Attachments:

• Test.java

[GoogleCodeExporter]

Thanks a lot.

Original comment by sergey.s...@gmail.com on 19 Nov 2010 at 2:02