Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Session table needs to be in UTF-8 on MySQL 5 #1110

Closed
rcubetrac opened this issue Jun 27, 2007 · 4 comments
Assignees
Labels
Milestone

Comments

@rcubetrac
Copy link

@rcubetrac rcubetrac commented Jun 27, 2007

Reported by @till on 27 Jun 2007 13:04 UTC as Trac ticket #1484456

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;

Keywords: utf8, mysql5, sessions
Migrated-From: http://trac.roundcube.net/ticket/1484456

@rcubetrac

This comment has been minimized.

Copy link
Author

@rcubetrac rcubetrac commented Aug 29, 2007

Status changed by @till on 29 Aug 2007 02:23 UTC

new => assigned

@rcubetrac

This comment has been minimized.

Copy link
Author

@rcubetrac rcubetrac commented Aug 29, 2007

Owner changed by @till on 29 Aug 2007 02:23 UTC

=> till

@rcubetrac

This comment has been minimized.

Copy link
Author

@rcubetrac rcubetrac commented Aug 29, 2007

Comment by @till on 29 Aug 2007 02:23 UTC

Changes both committed to trunk and devel-vnetx

@rcubetrac

This comment has been minimized.

Copy link
Author

@rcubetrac rcubetrac commented Aug 29, 2007

Status changed by @till on 29 Aug 2007 02:23 UTC

assigned => closed

@rcubetrac rcubetrac closed this Aug 29, 2007
@rcubetrac rcubetrac added this to the 0.1-rc2 milestone Mar 20, 2016
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Projects
None yet
2 participants
You can’t perform that action at this time.