Re: Binary - Data into Oracle 8i over ODBC
| From: | szii | Date: | Sun, 01 Oct 2000 21:38:08 +0000 |
| Subject: | Re: Binary - Data into Oracle 8i over ODBC | ||
| References: | 1 | Groups: | php.db |
| Request: | Send a blank email to php-db+get-3196@lists.php.net to get a copy of this message | ||
Check out the variations of BLOB data...there's a long version and you can
specify "for binary data" when you create the column.
-Szii
On Sun, 01 Oct 2000, Jürgen Stary wrote:
> > 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
> ______________________________________________