Rather than going through a loop to convert characters, would it be useful to you to see the string escaped as HEX values? (http://dev.mysql.com/doc/mysql/en/Hexadecimal_values.html)
Other than that I think you would have to search using one of the string comparison functions and escaped character sequences (http://dev.mysql.com/doc/mysql/en/String_comparison_functions.html) Just a thought, Shawn Green Database Administrator Unimin Corporation - Spruce Pine Victor Pendleton <[EMAIL PROTECTED]> wrote on 08/18/2004 05:03:12 PM: > There is not a function equivalent to Oracle's dump but you could throw > together a substring loop that prints out the ascii value of each character. > > -----Original Message----- > From: Martin Gainty > To: [EMAIL PROTECTED] > Sent: 8/18/04 3:24 PM > Subject: contains? > > > > is there way to interrogate what is inside a column specifically a > special > character? > thanks, > > Martin Gainty > > _________________________________________________________________ > Express yourself instantly with MSN Messenger! Download today - it's > FREE! > http://messenger.msn.click-url.com/go/onm00200471ave/direct/01/ > > > -- > MySQL General Mailing List > For list archives: http://lists.mysql.com/mysql > To unsubscribe: > http://lists.mysql.com/[EMAIL PROTECTED] > > -- > MySQL General Mailing List > For list archives: http://lists.mysql.com/mysql > To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED] >
