forcemax's

SMF의 소스 중 Sources/Load.php 파일을 수정한다.

147     // Most database systems have not set UTF-8 as their default input charset.
148 /*  if (isset($db_character_set) && preg_match('~^\w+$~', $db_character_set) === 1)
149         db_query("
150             SET NAMES $db_character_set", __FILE__, __LINE__);
151 */

P.S. DB가 UTF-8로 셋팅되어 있을 경우에만 해당된다.

Comment +0

If you get an error message during install beginning something like this:

# SQL=Specified key was too long; max key length is 1000 bytes:

This is probably because of your MySQL servers default character set is UTF-8 and using this encoding, every character is 16bits while others are 8bits. So, every column will have a doubled length.

You can change default character set for your tables. Open installation/sql/mambo.sql file in your favorite editor and change the string

# TYPE=MyISAM;

with exactly this:

# TYPE=MyISAM, DEFAULT CHARACTER SET latin1;

[for latin1, you may use something else]

Save the file, start mambo install again.

(Source: Mambo Forums)

Comment +0