Hello Gavin,

GS> On Sunday, July 4, 2004, 11:59:43 PM, Jamis wrote:

>>>>SQLite::Database.quote(...) will do just that. It is new in 1.2.9.1.
>>> 
>>> 
>>> Does that take care of NULs?
>>> 
>>> Gavin

>> What do you mean? Can you give me an example?

GS> SQLite, I believe, chokes on strings that have NUL (0) characters in
GS> them, because C uses \0 as the string terminator and, well, everyone
GS> else should work like that too.  Or something.  Since SQLite stores
GS> everything as a string (I believe), you have no chance of storing
GS> binary data in SQLite directly -- that's too likely to contain \0 in
GS> it.

SQLite 3.0 has support for BLOB's.


-- 
 Best regards,                        emailto: scholz at scriptolutions dot com
 Lothar Scholz                        http://www.ruby-ide.com
 CTO Scriptolutions                   Ruby, PHP, Python IDE 's