Hello. This is my first post to this mailling list. My name is Yoshikazu, I'm Japanese. I found some problems for multi-bytes character enviroment like Japanese.
One problem may happened only with MySQL 5. If an attached file name contains multi-bytes character in UTF-8, that file name will covert to question mark. (ex. "????????????.jpg") This is caused by that 'session' table character set was ASCII. MySQL 5 convert UTF-8 session.vars to ASCII when the attached file name was stored in session. So, I think 'session' table character set shoud be UTF-8. I have already succeeded. This problem was solved by changing session table character set to utf8. == ALTER TABLE `session` DEFAULT CHARACTER SET utf8 COLLATE utf8_general_ci, CHANGE `sess_id` `sess_id` VARCHAR( 40 ) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL, CHANGE `ip` `ip` VARCHAR( 15 ) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL, CHANGE `vars` `vars` text CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL; -- /** ----------------------------------------- * Yoshikazu Tsuji @ church.ne.jp * * E-mail : [EMAIL PROTECTED] * Web : http://church.ne.jp/ * ------------------------------------------ */
