在数据库开发过程,经常回处理中文字符,或者中英文混合的字符串。
此时,在mysql建立数据库的时候应该设定相应的编码:
需要在最后设定默认编码格式。
而mysql本身的默认字符集为latin1,因此还需要在my.ini中更改设置:
[mysql]
default-character-set=utf8
# The default character set that will be used when a new schema or table is
# created and no character set is defined
default-character-set=utf8
然后在数据库中操作中英文就可以了。
但是在通过sql yog查看数据库的时候,由于采用的版本不同,默认打开时会发生乱码的情况。此时需要在sql yog的登陆界面,选择default character 为gbk,应该和建立库的默认字符集一致,此时打开数据库后,就可以正常显示中文了。
此时,在mysql建立数据库的时候应该设定相应的编码:
- if(stat.execute("CREATE TABLE IF NOT EXISTS " + table + " ("
- + "ID INT AUTO_INCREMENT PRIMARY KEY ," + "type int ,"
- + "reset int," + "jobName VARCHAR(500)," + "sendType int,"
- + "dateTime DATETIME," + "cronTime VARCHAR(500),"
- + "calendar VARCHAR(500)," + "dayInterval int,"
- + "clientUser VARCHAR(500)," + "ClientMail VARCHAR(500),"
- + "mailSender VARCHAR(500)," + "mailReceiver VARCHAR(500),"
- + "mailCC VARCHAR(500)," + "mailTitle VARCHAR(500),"
- + "mailContent VARCHAR(500)," + "attachment VARCHAR(500),"
- + "number VARCHAR(500)," + "message VARCHAR(500)"
- + ")default character set gbk")) { }
而mysql本身的默认字符集为latin1,因此还需要在my.ini中更改设置:
[mysql]
default-character-set=utf8
# The default character set that will be used when a new schema or table is
# created and no character set is defined
default-character-set=utf8
然后在数据库中操作中英文就可以了。
但是在通过sql yog查看数据库的时候,由于采用的版本不同,默认打开时会发生乱码的情况。此时需要在sql yog的登陆界面,选择default character 为gbk,应该和建立库的默认字符集一致,此时打开数据库后,就可以正常显示中文了。