Radicore Forum: Bug Reports » Fatal Error: MySQL error: 1271

Home » RADICORE development » Bug Reports » Fatal Error: MySQL error: 1271

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

Re: Fatal Error: MySQL error: 1271 [message #777 is a reply to message #776]

Wed, 18 April 2007 19:20

AJM
Messages: 2368
Registered: April 2006
Location: Surrey, UK

Senior Member

The message "illegal mix of collations" means that you are not using the same collation (character set) for all your database columns. Although MySQL will allow you to mix collations, it is definitely not a good idea.

You should use the same collation for all fields. If you want to cater for all possible languages you should use "utf8_unicode".

Tony Marston
http://www.tonymarston.net
http://www.radicore.org

Report message to a moderator

[Message index]

		Fatal Error: MySQL error: 1271 By: mrbun on Wed, 18 April 2007 16:40
		Re: Fatal Error: MySQL error: 1271 By: AJM on Wed, 18 April 2007 19:20
		Re: Fatal Error: MySQL error: 1271 By: mrbun on Thu, 19 April 2007 03:04
		Re: Fatal Error: MySQL error: 1271 By: AJM on Thu, 19 April 2007 04:24

Previous Topic:	multi2
Next Topic:	delete user fails

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

] [

]

Current Time: Sun Nov 24 19:19:27 EST 2024

Total time taken to generate the page: 0.03282 seconds