MySQL encoding, encoding in spring configuration, Struts Chinese

Three encoding problems today

1. MySQL stored and removed data garbled, because the new database does not support Chinese, modify the database code to GBK or UTF-8

2. to configure data connections in spring, you must specify the data encoding in jdbcurl:

JDBC: mysql: // 127.0.0.1: 3306/auction? Useunicode = true & amp; characterencoding = GBK

Note that this XML file cannot be directly used, but the transferred & amp;

3. We recommend that you use UTF-8 for Chinese encoding in struts because of Ajax. If you use GBK for a discount, see

Http://www.blogjava.net/errorfun/archive/2006/12/30/91000.html

Http://blog.csdn.net/feng_sundy/article/details/139647

Ultraedit does not handle all kinds of codes well. notepad ++ does well in processing. In most cases, the codes can be correctly identified and can be freely converted. If you do not know the encoding format, use Notepad ++ to open it.