Re: #HY000Illegal mix of collations for operation 'concat'
Posted by: Reggie Burnett
Date: November 12, 2004 09:41AM

Thanks Brennon

One thing to know about this issue is that you can work around it without the new version. Basically the problem comes from the server not being able to compare utf-8 and latin1 strings. Our new character set support is good but can be better.

To avoid this issue using the current code on a latin1 table, you would need to use the CAST and CONVERT functions to make sure your literals were latin1. When 1.0.2 comes out, you will still need to use these functiosn when the literals are a different charset than what you selected. So if 99% of your table columns are latin1 but once table is multi-lingual, then you would need to use the CAST and CONVERT operations to make sure those literals were treated correctly.


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.