Regarding to the manual there is no difference between blob and text fields,
except that searching on text fields is case-insensitive and searches on
blobs are binary safe.
However, i'm quite stunned if you say you cannot use mysql_query to query
binary data, i've never experienced this problem:
mysql> create table test (b tinyblob);
Query OK, 0 rows affected (0.00 sec)
mysql> insert into test values ('test');
Query OK, 1 row affected (0.00 sec)
mysql> select * from test;
+--+
| b|
+--+
| test |
+--+
1 row in set (0.00 sec)
mysql> select * from test where b like '%t%';
+--+
| b|
+--+
| test |
+--+
1 row in set (0.00 sec)
with both PHP and delphi i did not experience any problem at all.
which version and environment are you using and can you reproduce it ?
- Original Message -
From: "WCBaker" <[EMAIL PROTECTED]>
To: "MySQL" <[EMAIL PROTECTED]>
Sent: Wednesday, March 21, 2001 4:42 AM
Subject: "text stored as binary" question posted earlier
> Hi all!
>
> Regarding my earler question about storing text as binary - I found no
> problem storing the text as mediumtext or longtext, and then dragging it
out
> with a normal "mysql_query ".This solves my problem.
>
> However, if anyone has other ideas I'd love to hear them!
>
> Thanks very much!
>
> -Warren
>
>
> -
> Before posting, please check:
>http://www.mysql.com/manual.php (the manual)
>http://lists.mysql.com/ (the list archive)
>
> To request this thread, e-mail <[EMAIL PROTECTED]>
> To unsubscribe, e-mail <[EMAIL PROTECTED]>
> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
>
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
