sql error USER

[RoCkFoRdGuN]

Hi there one of my users are getting a sql error when he tries to login

so i went to his name and wanted to do some digging on whats going on

I went to user administration
found his name but got this error

_____________________________


General Error
SQL ERROR [ mysql4 ]

Illegal mix of collations (latin1_swedish_ci,IMPLICIT) and (utf8_general_ci,COERCIBLE) for operation '=' [1267]

SQL

SELECT user_id FROM phpbb_users WHERE username_clean = 'ǃ3lem3ntǃ'

BACKTRACE

FILE: includes/db/mysql.php
LINE: 158
CALL: dbal->sql_error()

FILE: includes/acp/acp_users.php
LINE: 92
CALL: dbal_mysql->sql_query()

FILE: includes/functions_module.php
LINE: 471
CALL: acp_users->main()

FILE: adm/index.php
LINE: 74
CALL: p_master->load_active()
_______________________________

Any ideas?

[Noxwizard]

You need to switch the collations on your phpbb_users table from latin to utf8.

[RoCkFoRdGuN]

Its only one user tho thats the funny thing and thats after i upgraded to phpbb3
How do i change it on phpmyadmin :"?

[Noxwizard]

In phpMyAdmin, choose your database on the left, then choose the phpbb_users table. Then on the structure tab, find the 'username_clean' row, and click the pencil. On that page, change the 'Collation' dropdown to 'utf8_general_ci'. Click 'Save' and you're done.