Mysql Charset Shoule Be UTF-8 #85

Closed
IndeedPlusPlus opened this Issue Mar 9, 2013 · 2 comments

Projects

None yet

2 participants

@IndeedPlusPlus

Maybe the charset towards the mysql server should be made utf-8 since all tables are using utf8_general_ci as their collation type.
in com/palmergames/bukkit/towny/db/TownySQLSource.java
line 101

this.dsn = ("jdbc:mysql://" + hostname + ":" + port + "/" + db_name);

should be changed to

this.dsn = ("jdbc:mysql://" + hostname + ":" + port + "/" + db_name + "?useUnicode=true&characterEncoding=utf-8");
@IndeedPlusPlus

Maybe allowing user to specify the whole dsn is a good idea.

@ElgarL
Owner
ElgarL commented Apr 1, 2014

Added.

@ElgarL ElgarL closed this Apr 1, 2014
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment