Page 1 of 1

Can't register account!

Posted: Thu Apr 23, 2009 11:48 pm
by Linda Carter
I tried to register one username in my board:
And the same returned this kind of error:
SQL ERROR [ mysql4 ]

Illegal mix of collations (latin1_swedish_ci,IMPLICIT) and (utf8_general_ci,COERCIBLE) for operation '=' [1267]
What should I do to fix this? It's only happening with this kind of username. :cry:

Re: Can't register account!

Posted: Fri Apr 24, 2009 5:21 am
by Lumpy Burgertushie
dont use the apostrophe in usernames. it is apparently not allowed with the character set(s) you are using.


Re: Can't register account!

Posted: Sat Apr 25, 2009 2:07 am
by Linda Carter
And how can we change that? What kinds of settings are preventing this from working?

I know that phpBB 2 is allowing me to use apostrophe in usernames. Not sure why phpBB 3.04 is not. :?:

Thanks :)