# [EMAIL PROTECTED] / 2003-06-17 10:59:13 +0200:
> On Mon, Jun 16, 2003 at 11:56:59PM +0200, Roman Neuhauser wrote:
> > # [EMAIL PROTECTED] / 2003-06-16 15:27:21 +0200:
> > > mysql> select * from unitest WHERE t LIKE 'A%';
> > > ERROR 1210: Wrong arguments to like
> >
> >
> > SELECT * FROM unitest WHERE <colname> LIKE CONVERT(_latin1'A%' USING utf8)
>
> thanks, that works.
> and yes, I need the absurd "CONVERT .. utf8 ... USING utf8",
> with out the CONVERT ist doesn't work.
absurd? your connection has latin1 as the character set, and you need
to compare apples to apples. as I said:
a) CONVERT()
b) SET CHARACTER SET
--
If you cc me or remove the list(s) completely I'll most likely ignore
your message. see http://www.eyrie.org./~eagle/faqs/questions.html
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
