.txt' OR filename = 'file2.txt'
was working and
SELECT * FROM files WHERE filename IN('file1.txt', 'file2.txt')
wasn't
Dusan
- Original Message -
From: Gleb Paharenko [EMAIL PROTECTED]
To: mysql@lists.mysql.com
Sent: Thursday, June 02, 2005 2:13 PM
Subject: Re: Illegal mix of collations
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
(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