Mambo/Joomla with SMF에서 UTF-8로 설정시 한글 깨짐
작업2007. 3. 2. 20:19
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로 셋팅되어 있을 경우에만 해당된다.
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로 셋팅되어 있을 경우에만 해당된다.
SQL=Specified key was too long; max key length is 1000 bytes:
작업2007. 3. 2. 17:44
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)
