Re: [libsql] ODBC + Blob field

[<re...@du...>]

Hi,

This is a good question and i don't know the answer myself to be honest.=
 
ODBC uses an odd method of escaping, just ' is replaced with '' (twice),=
 
i am not  sure how it handles or should handle binary zero's. Other 
databases use a backslash for escaping, making escaping a binary zero 
also easy (although i messed up and only recently fixed mysql blob 
reading thanks to a bug report).
libsql has escape functions that behave database specific (=3D backslash=
 
for mysql/sqlite; double quote to insert a single quote in ODBC). If 
anyone (empirically) finds the answer i'd be happy to implement it.

kind regards,

Rene

Leonardo M. Ram=E9 schreef:
> Does anybody knows how to insert or update a blob field in an ODBC con=
nection?
>
> Leonardo M. Ram=E9
> http://leonardorame.blogspot.com
>
> __________________________________________________
> Do You Yahoo!?
> Tired of spam?  Yahoo! Mail has the best spam protection around 
> http://mail.yahoo.com 
>
> ----------------------------------------------------------------------=
---
> Using Tomcat but need to do more? Need to support web services, securi=
ty?
> Get stuff done quickly with pre-integrated technology to make your job=
 easier
> Download IBM WebSphere Application Server v.1.0.1 based on Apache Gero=
nimo
> http://sel.as-us.falkag.net/sel?cmd=3Dlnk&kid=3D120709&bid=3D263057&da=
t=3D121642
> _______________________________________________
> libsql-discussion mailing list
> lib...@li...
> https://lists.sourceforge.net/lists/listinfo/libsql-discussion
>