If you're trying to store text in the database, try using column type 'text'
instead of 'blob'. Blob is used for storing binaries so that's what it's
expecting...
-mic
----- Original Message -----
From: "Ed Meyer" <[EMAIL PROTECTED]>
To: "PHP" <[EMAIL PROTECTED]>
Sent: Friday, February 16, 2001 10:32 AM
Subject: [PHP-WIN] Interbase/PHP Blob types
I've seen some conversation on this list about blob types but never really
an answer. I'm having the problem where I'm trying to insert text into a
blob but I'm getting the error message:
Warning: Interbase: conversion error from string "BLOB" in filename on line
13
Here's more info about the table and sql I'm using
<------------------------------------------->
create table memo (
id char(2) not null primary key,
memo blob sub_type 1);
insert into memo (id, memo) values ('2', 'Sample Text');
<------------------------------------------->
I've been told to use:
insert into memo (id, memo) values (:id, :memo) and convert the variable to
:memo but that doesn't work either - instead I get a parse error on line
whatever.
If more info is needed, please let me know. Thanks!
Ed Meyer
Smarts Broadcast Systems
--
PHP Windows Mailing List (http://www.php.net/)
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
To contact the list administrators, e-mail: [EMAIL PROTECTED]
