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
>
|
