RE: Select Binary Field when UTF8 and Collate

2004-10-15 Thread Kevin Cowley
;D Tel: 0118 902 9099 (direct line) Email: [EMAIL PROTECTED] Web: http://www.alchemetrics.co.uk > -Original Message- > From: Jeremy March [mailto:[EMAIL PROTECTED] > Sent: 15 October 2004 06:24 > To: [EMAIL PROTECTED] > Subject: Re: Select Binary Field when UTF8 and

Re: Select Binary Field when UTF8 and Collate

2004-10-14 Thread Jeremy March
> We have a database that has one particular table, searchdata, that has > the > following columns > > BINARY key_low(5) > BINARY key_high(5) > VARCHAR searchss(255) > > The following query, when the SET QUERY UTF8 option is present, > doesn't work > because MySQL encodes the binary field. > A

Select Binary Field when UTF8 and Collate

2004-10-14 Thread Kevin Cowley
We have a database that has one particular table, searchdata, that has the following columns BINARY key_low(5) BINARY key_high(5) VARCHAR searchss(255) The following query, when the SET QUERY UTF8 option is present, doesn't work because MySQL encodes the binary field. Any ideas how we get aroun