Re: #HY000Illegal mix of collations for operation 'concat'
Posted by: Brennon Williams
Date: November 14, 2004 04:58AM

Okay Allan,

The place I was getting the error was when I was trying to call SELECT statements with VARCHAR variables so, the following was the normal command string:

SplitTXT = "SELECT * FROM <tablename> WHERE <field> = '<fieldvalue>'"

If your tables are set to use the latin charset/collation then you will need to change the above statement to

SplitTXT = "SELECT * FROM <tablename> WHERE <field> = CONVERT('<fieldvalue>' USING latin1);"

This executes for me without error now, I only hope it does for you. It would appear though that Reggie Says this syntax will still be required even with the next release.

Cheers & Beers
Brennon Williams

Options: ReplyQuote

Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.