Home IT Linux Windows Database Network Programming Server Mobile  
           
  Home \ Database \ MySQL 5.6 database code changes     - lack of SWAP space during installation of Oracle (Database)

- File encryption and decryption of Linux security mechanisms (Linux)

- Learn about EditText little depth (Programming)

- JavaScript cross-browser event object library (Programming)

- Depth study and understanding for individual users suicide DDoS attacks (Linux)

- Use SocketServer write a sockets program (Programming)

- Ubuntu 14.04 / 13.10 users how to install Ubuntu Touch core applications (Linux)

- How SSHfs mount a remote file system on Linux (Linux)

- The FreeBSD zfs: failed with error 6 Error Resolution (Linux)

- Oracle bdump file soaring (Database)

- Hadoop 2.2.0 installation development environment (standalone pseudo-distributed mode) (Server)

- Java multithreading easy to confuse the concept (Programming)

- ntop monitoring software configuration and installation (Linux)

- Red Hat Linux mount U disk (Linux)

- Perl said method B if A judge (Programming)

- DNF Command Tutorial (Linux)

- Android project using the command to create and install the package (Programming)

- NGINX Plus now fully supports HTTP / 2 (Server)

- Ubuntu deploying Solr (4.4) to Tomcat (7.0.53) (Server)

- numpy and SciPy installation under Python for scientific computing package (Linux)

 
         
  MySQL 5.6 database code changes
     
  Add Date : 2018-11-21      
         
       
         
  Today garbled on the test environment, but the same program in a formal environment (Ali cloud) no distortion. I checked the mysql coding found coded test environment is not all utf8. It needs to be mysql encoding are set to utf8.

Solutions are as follows:

1, the mysql installation directory my-default.ini copy, rename my.ini (because mysql5.6 no my.ini file)

2, add the following content my.ini, red box is a modified part:

[Mysql]
port = 3306
default-character-set = utf8

[Mysqld]
character-set-server = utf8

3, restart the mysql service, modify the coding end.

Coding look mysql modified: SHOW VARIABLES LIKE '% character%'. Should all utf8. Again insert data into the database, there is no distortion.
     
         
       
         
  More:      
 
- Nginx Module Development - get user ip (Server)
- CentOS7 management of systemd (Linux)
- Linux upgrade GCC 4.8.1 clear and concise tutorials (Ubuntu 12.04 64-bit version as an example) (Linux)
- C ++ pointer of the (error-prone model) (Programming)
- Spring AOP (Programming)
- MongoDB learning Notes (2) basic connection example of -Nodejs and MongoDB (Database)
- Zabbix configuration of SNMP (Server)
- Depth understanding of C language (Programming)
- Oracle 12c detailing the new features (Database)
- How to properly set up a Linux swap partition (Linux)
- Ubuntu Server security risk checks (Linux)
- Atheros AR8161 / AR8162 network card driver problem solving in CentOS 6.4 (Linux)
- The next key to install Linux bash script PowerShell (Linux)
- 10 useful Linux command line tips (Linux)
- Installation and management of Linux applications (Linux)
- Java interface and inheritance (Programming)
- CentOS directory structure Explanation (Linux)
- Ubuntu Control Panel to resolve network-manager icon display issue (Linux)
- Virtual Judge environment to build and configure under Ubuntu (Server)
- Linux filtration empty file command summary (Linux)
     
           
     
  CopyRight 2002-2016 newfreesoft.com, All Rights Reserved.