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 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) against a
column of type
> MEDIUMTEXT/MEDIUMBLOB that contains binary data...

I know. :-) I didn't know, though, if you wanted to match a NUL byte,
the literal string "\017", ASCII 17, or what.


> how can i encode the byte 17 into a mysql string? is it possible?

Can't you just put it in the string like any character? Or does it cause
a problem?

I guess you could use the CHAR() function otherwise?

... WHERE column LIKE CONCAT('%stuff', CHAR(17), 'stuff%');

I think!


Matt


-- 
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:    http://lists.mysql.com/[EMAIL PROTECTED]

Reply via email to