Re: Interbase/PHP Blob types

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" <edmeyer@smartsbroadcast.com> To: "PHP" <php-windows@lists.php.net> 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