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
