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

Note: See TracTickets for help on using tickets.