Binary - Data into Oracle 8i over ODBC
| From: | Jürgen Stary | Date: | Sun, 01 Oct 2000 21:21:26 +0000 |
| Subject: | Binary - Data into Oracle 8i over ODBC | ||
| Groups: | php.db | ||
| Request: | Send a blank email to php-db+get-3195@lists.php.net to get a copy of this message | ||
Hello,
I´m try to figure out, how to transfer Binarys (Mp3´s) into a Blob-field in
an Oracle Database with help of PHP.
I tried several things but nothing worked yet. I tried to transform the data
I read via fread into bin2hex, but then Oracle tells me, my string is too
long.
If I don´t do this transformation Oracle gets an "Syntax error or Access
Violation, SQL state 37000 in SQL ExecDirect" . Does anybody has experience
with this problems or did this successfully.
I´m working with Apache 1.3.12 Php 3.0.16, Oracle 8i, on Windows2000.
Thanks for your help,
Kind regards, Jürgen
_______________________________________________
Jürgen Stary
Junior Software Entwickler
Utomi AG
Stefan-George-Ring 19, 81929 München
Tel. +49 89 930 906-33, Mobil +49 173 614 690 6,
Fax +49 89 930 906-99
mailto:jstary@utomi.de
______________________________________________
NEU! Ihr eigenes WorldWideWeb mit my-files.de
kostenlos - hier starten http://www.my-files.de
______________________________________________