Re: "text stored as binary" question posted earlier

[René Tegel <tegel@xxxxxxxxx>]

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" <WCBaker@xxxxxxxx>
To: "MySQL" <mysql@xxxxxxxxxxxxxxx>
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 <mysql-thread68933@xxxxxxxxxxxxxxx>
> To unsubscribe, e-mail <mysql-unsubscribe-tegel=chello.nl@xxxxxxxxxxxxxxx>
> 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 <mysql-thread68956@xxxxxxxxxxxxxxx>
To unsubscribe, e-mail <mysql-unsubscribe-treed=ultraviolet.org@xxxxxxxxxxxxxxx>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php