|
Re: Objects in Database: msg#00111db.sqlite.general
Dennis Przybyla wrote: > I would say that is a limitation of SQLite. Basically you can only store > text. You can not really store a blob. > > I would fix this by implementing a size parameter in the exec function > so you don't have to rely on NULL terminated strings. > SQLite does contain a "size" parameter and is capable of storing binary data, at least in theory. The problem is with the SQL language. How do you propose to insert a '\000' character using an INSERT statement? -- D. Richard Hipp -- drh-X1OJI8nnyKUAvxtiuMwx3w@xxxxxxxxxxxxxxxx -- 704.948.4565 ------------------------ Yahoo! Groups Sponsor ---------------------~--> Get 128 Bit SSL Encryption! http://us.click.yahoo.com/JjlUgA/vN2EAA/xGHJAA/EbFolB/TM ---------------------------------------------------------------------~-> To unsubscribe from this group, send an email to: sqlite-unsubscribe-VgYJa0VH1e9BDgjK7y7TUQ@xxxxxxxxxxxxxxxx Your use of Yahoo! Groups is subject to http://docs.yahoo.com/info/terms/ |
|
| <Prev in Thread] | Current Thread | [Next in Thread> |
|---|---|---|
| Previous by Date: | Re: sqlite_exec_vprintf & sqlite_exec_printf: 00111, D. Richard Hipp |
|---|---|
| Next by Date: | Re: memory usage: 00111, D. Richard Hipp |
| Previous by Thread: | Re: Objects in Databasei: 00111, Dennis Przybyla |
| Next by Thread: | Re: Objects in Database: 00111, Mike |
| Indexes: | [Date] [Thread] [Top] [All Lists] |
| News | FAQ | advertise |