phpBB + French language = Pb

[chlankboot]

Hi all,

Have anyone tried to install french language on phpBB?
When trying i get this error:

General Error

SQL ERROR [ mysql4 ]

Incorrect string value: '\xE2\x80\x8E' for column 'lang_english_name' at row 1 [1366]

SQL

INSERT INTO phpbb_lang (lang_iso, lang_dir, lang_english_name, lang_local_name, lang_author) VALUES ('fr', 'fr', 'French (Standard)‎', 'Français‎ (Standard)', 'Elglobo')

BACKTRACE

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

FILE: includes/acp/acp_language.php
LINE: 838
CALL: dbal_mysql->sql_query()

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

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

Could this be due to the "ç" char within the word "Français"?
I installed spanish and italien with no problem but same problem appeared when trying to install arabic !!
(my php is updated to x10 v2)

[LHVWB]

Is your forum set to utf-8? If not then this could be causing the problem. It shouldb't have anything to do with the php version.

Maybe you should ask about this on the phpbb3 forums, they are more likely to know about this sort of specialised issue.

[chlankboot]

thanks dude for enlighting me about utf8,
in fact by default (and i dont know why) the mysql db is configured with some scandinavian language ???). to make it work, two tables have 2 be changed to utf8 : phpbb_lang and phpbb_log (including the fields collation), but i dont exclude problems later so i have the painfull task to do this for all the rest of tables and fields.
by the way, is there any script that can do the job ?
Thks again

[LHVWB]

I don't know of any script that can easily do the job, but you can use phpMyAdmin to change the structure of the table. I am not sure about PHPBB3, but in SMF there is an option somewhere which says, "convert all database entities to UTF-8", or something similar, so have a look to see if phpbb3 has one.

[kkenny]

Have you tried searching your ACP/phpbb3 for the option that verbsite mentioned? If there is one, it will fix everything hopefully. If not then I think you have to use phpmyAdmin to fix it.

EDIT :: OOPS. I didn't notice verbsite also mentioned the phpmyadmin solution. So sorry ><

[chlankboot]

thank you all guys for your help.

problem is now completely solved and i installed all kinda wierd chars sets (french, arabic), just spent 1 hour converting everything including fields to utf8:nuts:. now it's working perfect.

i will see if there is the option to convert everything to utf8, if i find something similar for phpbb8 i'll post it here so it might help others in the future.

[LHVWB]

* Closed *

If you find anything about converting database characters in phpbb3, you should be able to re-open this thread.