Home PC Games Linux Windows Database Network Programming Server Mobile  
           
  Home \ Database \ Several reasons MySQL garbled     - Manually generate AWR reports (Database)

- Subquery Oracle study notes (Database)

- Mongo-connector integrated MongoD to achieve incremental Solr index (Server)

- How to avoid two Chrome icon appears in ELementary OS Freya (Linux)

- List Leaves (Programming)

- JDK installation and configuration environment variable under linuxb (Linux)

- OpenSUSE installation on CentOS6 (GUI) (Linux)

- Oracle 10g relations with the constraint of column properties NULLABLE (Database)

- How to add a new hard disk without restarting the CentOS 7 / RHEL 7 virtual machine (Linux)

- To set up the printer use Nagios Monitoring Server (Server)

- Ubuntu 15.04 using the Eclipse 4.4, Java 8 and WTP (Linux)

- Linux server security - the web server configuration (Linux)

- The several technical presentation Raid under Linux (Linux)

- SQL Server 2012 failover looksalive check and is alive check (Database)

- Under Ubuntu 15.04 installation JDK8 (Linux)

- Oracle 11g maintenance partitions - Adding Partitions (Database)

- C ++ stderr / stdout redirected to a file (Programming)

- LNMP Note: Addressing mail function can not send mail (Server)

- Mac OS X system setup Google Go language development environment configuration tool Sublime Text 2 (Linux)

- Ubuntu 15.04 install Complete Guide (Linux)

 
         
  Several reasons MySQL garbled
     
  Add Date : 2018-11-21      
         
         
         
  MySQL garbled reason, is nothing more than the following reasons:

1, the distortion prior to deposit into the database

2, in the presence of the process into the database garbled

3, deposit into the database garbled

Want to know where the distortion is very simple, printed in the background will know.

Now that we know where the problem is, that the solution is very simple:

1, jsp set the encoding is utf-8, to ensure the spread of the background is the encoding utf-8

2, the database connection plus in such a period of jdbc: mysql: // localhost: 3306 / test? useUnicode = true & characterEncoding = utf-8, to ensure that the transfer process is utf-8's.

3, the database is encoded as utf-8, or set in Config settings are also in line my.ini, attention is my.ini in the default-character-set to change two places

4, url or easyui garbled, you can try in the tomcat's server.xml

< Connector port = "8080" protocol = "HTTP / 1.1"
               connectionTimeout = "20000"
               redirectPort = "8443" />
To

< Connector port = "8080" protocol = "HTTP / 1.1"
               connectionTimeout = "20000"
               redirectPort = "8443" URIEncoding = "utf-8" />
     
         
         
         
  More:      
 
- CentOS 6.x and CentOS7 install MPlayer (Linux)
- Java programmers talk about those advanced knowledge and direction (Programming)
- Debian installation (Linux)
- CentOS 6.5 installation and deployment SVN 1.8.10 (Linux)
- Make full use of the Raspberry Pi SD card space (Linux)
- HTTP and HTTPS request response process difference (Linux)
- How to add a new hard disk without restarting the CentOS 7 / RHEL 7 virtual machine (Linux)
- Linux SVN account password to save your settings (Linux)
- CentOS install SystemTap-2.6 (Linux)
- Linux server operating system security configuration (Linux)
- Ubuntu 15.04 / 14.04 install Ubuntu After Install 2.6 (Linux)
- To record command input under Linux (Linux)
- Using shell users or virtual users to login to pureftpd (Linux)
- CentOS yum install LNMP PHP5.4 version (Server)
- Android official recommendation: DialogFragment create dialog (Programming)
- Raspberry Pi configuration wireless hotspot (Linux)
- To install MySQL 5.6 binary packages under CentOS 6.4 64bit (Database)
- ORA-12547: TNS: lost contact error Solution (Database)
- Ubuntu update bug fixes Daquan (Linux)
- Linux script commands - terminal recorder (Linux)
     
           
     
  CopyRight 2002-2022 newfreesoft.com, All Rights Reserved.