search

bbqchickenrobot / csharp-sqlite

Automatically exported from code.google.com/p/csharp-sqlite
Other
0 stars 0 forks source link

C#-SQLite blobs and SQLite blobs not compatible. #47

Closed GoogleCodeExporter closed 9 years ago

GoogleCodeExporter commented 9 years ago 
Binary blobs get converted via Encoding.UTF8.GetString to store;  This may
cause problems for some sequence of bytes during SELECT statement

Need to revisit storage and retrieval of blobs

Original issue reported on code.google.com by noah.hart@gmail.com on 29 Jan 2010 at 4:16

GoogleCodeExporter commented 9 years ago 
If you use the Latin-1/ISO-8859-1 encoding, you won't lose anything. It's 
basically 
binary as text.

Original comment by jdha...@gmail.com on 1 Feb 2010 at 9:28

GoogleCodeExporter commented 9 years ago 
@jdhardy Are you sure? Sqlite version < 3 store all blobs a string but the 
sqlite 3
version not, in my opinion.

Original comment by seeseekey on 9 Feb 2010 at 12:23

GoogleCodeExporter commented 9 years ago 
Try again with 2010-2-16 check in;  Patches added which should improve that 
behavoir

Original comment by noah.hart@gmail.com on 16 Feb 2010 at 11:43

GoogleCodeExporter commented 9 years ago 
Reading from normal sqlite databases works. But write a blob not. It throws a
exception in vdbemem_c.cs on line 870 if i bind a blob to the database.

Original comment by seeseekey on 17 Feb 2010 at 3:24

GoogleCodeExporter commented 9 years ago 
I am unable to replicate the error;  Please submit sample code

Original comment by noah.hart@gmail.com on 20 Feb 2010 at 4:51

GoogleCodeExporter commented 9 years ago 
I had attach a test project.

Original comment by seeseekey on 22 Feb 2010 at 11:51

Attachments:

GoogleCodeExporter commented 9 years ago 
Updates posted today which fix this this error

Original comment by noah.hart@gmail.com on 24 Feb 2010 at 1:18

GoogleCodeExporter commented 9 years ago 
The update works :)

Original comment by seeseekey on 19 Mar 2010 at 1:29