Bug tracker

This ticket has been moved to our new tracker. Open Ticket PHPBB3-2145 now.

Database encoding do not support mutibyte language (support request)

I have installed phpbb3 beta3 version,At the same time,I translated it into Chinese(Simplified Chinese),But when the installation ready to insert the simple data,an error happend.

I had analize the database structure file

Found the default encoding is utf8_bin,and I change it into utf8_unicode_ci,it works


I do that (my default editor is vim70)

vi mysql_41_schema.sql

:%s/utf8_bin/utf8_unicode_ci/g

Comments / History

Posted by Acyd Burn (Server Manager) on Nov 15th 2006, 11:24

No, utf8_bin is correct, utf8_unicode_ci would not work and is also not intended to work with phpBB.

Which problems do you experience?

Posted by freechoice on Nov 15th 2006, 11:36

under the folder called languages/language pack/

there's file called iso.txt, right?

when it contain a multibyte character, you will see the error

if not,at the background acp ,you change the language local name

ok,you see

the name changes to ????????

when i change it to utf8_unicode_ci,everything goes ok

Posted by Acyd Burn (Server Manager) on Nov 15th 2006, 14:03

Are you sure you change the local name only? The english name is not supposed to hold utf8 data - also you said the error was on installation - within the language pack management i am able to enter unicode character for the local name just fine.

Please be as specific as possible.

Posted by DavidMJ (Former Team Member) on Nov 19th 2006, 14:32

iso.txt should not hold UTF-8 encoded data.

Linked ticket with changeset: r7235

Action performed by DavidMJ (Former Team Member) on Mar 27th 2007, 23:22

Ticket details

Related SVN changesets