Opened 6 years ago
Closed 6 years ago
#1484456 closed Bugs (fixed)
Session table needs to be in UTF-8 on MySQL 5
| Reported by: | till | Owned by: | till |
|---|---|---|---|
| Priority: | 5 | Milestone: | 0.1-rc2 |
| Component: | Database | Version: | 0.1-rc1 |
| Severity: | major | Keywords: | utf8, mysql5, sessions |
| Cc: |
Description
From the mailinglist:
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;
Change History (2)
comment:1 Changed 6 years ago by till
- Owner set to till
- Status changed from new to assigned
comment:2 Changed 6 years ago by till
- Resolution set to fixed
- Status changed from assigned to closed

Changes both committed to trunk and devel-vnetx