Hello.
Usually debugging of such kind of problems starts with examination of
the output of:
show variables like '%char%';
show variables like '%colla%';
Send the output of:
show create table your_table;
>Hello,
>
>I have problem which I don't understand.
>
>if I send command (from Query Browser or from C++ Builder application)
>SELECT FileName FROM Files WHERE FileName = 'FILE1.TXT' OR FileName =
>'FILE2.TXT'
>query executes without any problem but command
>SELECT FileName FROM Files WHERE FileName IN ('FILE1.TXT', 'FILE2.TXT')
>throws error "illegal mix of collations for operation 'IN' "
>
>I thought that IN is somehow by optimizer translated to ORs
>Could someone explain me why first query is OK and second not? Please.
>
>I'm using WinXP SP2 and MySQL 4.1.9-nt-log
>databases and tables use CHARSET=latin2 COLLATE=latin2_czech_cs
>I already read some articles about the topic in MySQL forum but they
>didn't helped me
>much.
>
>Thanks in advance
>
>Dusan Pavlica
Du$an Pavlica <[EMAIL PROTECTED]> wrote:
--
For technical support contracts, goto https://order.mysql.com/?ref=ensita
This email is sponsored by Ensita.NET http://www.ensita.net/
__ ___ ___ ____ __
/ |/ /_ __/ __/ __ \/ / Gleb Paharenko
/ /|_/ / // /\ \/ /_/ / /__ [EMAIL PROTECTED]
/_/ /_/\_, /___/\___\_\___/ MySQL AB / Ensita.NET
<___/ www.mysql.com
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
