#HY000Illegal mix of collations for operation 'concat'
Posted by: lord soth
Date: November 05, 2004 03:13PM

Hello, just upgraded to 4.1. server and upgraded to the new connector for .NET

After having issues with not returning any data I noticed I had to change the parameters from using the '@' to '?'. Now i'm having this issue when just executing a normal concat.

Is there any information as to the changes from ByteFX to the new connector also? It would be nice to see what changes were made.

Thanks

#HY000Illegal mix of collations for operation 'concat'
concat(lname, ', ', fname, ', ', mi) as FullName
character_set_client, connection, database, results, server are = latin1
character_set_system = utf8
collation_connection=latin1_swedish_ci
collation_database=latin1_swedish_ci
collation_server=latin1_swedish_ci

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.