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 : yskzt@church.ne.jp
- Web : http://church.ne.jp/
*/