RE: Problem with LIKE/REGEXP

2003-11-06 Thread George Moschovitis
What are you actually trying to match with \017? As far as I know, it's treating the \0 part as a NUL byte and trying to match that. Are you trying to match a NUL byte? Or are you trying to match ASCII 17 or something? Hello matt, i am trying to match a binary string (with binary data)

Re: Problem with LIKE/REGEXP

2003-11-06 Thread Matt W
Hi George, - Original Message - From: George Moschovitis To: [EMAIL PROTECTED] Sent: Thursday, November 06, 2003 9:03 AM Subject: RE: Problem with LIKE/REGEXP What are you actually trying to match with \017? As far as I know, it's treating the \0 part as a NUL byte and trying

Problem with LIKE/REGEXP

2003-11-05 Thread George Moschovitis
Hello everyone! I have a table with a MEDIUMBLOB column: CREATE TABLE mytab ( oid INTEGER ... odata MEDIUMBLOB ); in the mediumblob field i store an encoded string (bytes). I would like to perform regular expression searches on this field here is an example that works

Re: Problem with LIKE/REGEXP

2003-11-05 Thread Hans van Dalen
Hi, What db type do u use? If I'm right InnoDB doesn't support Free text search... bye Hans At 14:29 5-11-03, you wrote: Hello everyone! I have a table with a MEDIUMBLOB column: CREATE TABLE mytab ( oid INTEGER ... odata MEDIUMBLOB ); in the mediumblob field i store an encoded

Re: Problem with LIKE/REGEXP

2003-11-05 Thread George Moschovitis
Here is some additional information: I tried with version 3.23 and version 4.0 And I am using MyISAM tables. This is not a full text search an there is no index on the column. any ideas? George Moschovitis -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To

Re: Problem with LIKE/REGEXP

2003-11-05 Thread Matt W
- Original Message - From: George Moschovitis To: [EMAIL PROTECTED] Sent: Wednesday, November 05, 2003 7:29 AM Subject: Problem with LIKE/REGEXP Hello everyone! I have a table with a MEDIUMBLOB column: CREATE TABLE mytab ( oid INTEGER ... odata MEDIUMBLOB ); in the mediumblob field i store