Hi George, 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?
http://www.mysql.com/doc/en/String_syntax.html Matt ----- 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 an encoded string (bytes). > I would like to perform regular expression searches on this field > > here is an example that works (produces matches): > > SELECT oid FROM mytab WHERE odata LIKE "[EMAIL PROTECTED]"\ngmosx%"; > > here is an example that doesnt work (no matches returned): > > SELECT oid FROM mytab WHERE odata LIKE "[EMAIL PROTECTED]"\017athens1234%"; > > the \017 character seems to be the problem since the following produces > matches: > > SELECT oid FROM mytab WHERE odata LIKE "[EMAIL PROTECTED]"_athens1234%"; > > I tried using a MEDIUMTEXT and/or REGEXP but without success! > > Any idea how to do string matches on string-encoded binary data? > > Thanks in advance for any info! > > George Moschovitis -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
