Home IT Linux Windows Database Network Programming Server Mobile  
           
  Home \ Database \ MySQL 5.6 database code changes     - Reason C ++ program running under Linux a segmentation fault core dumped in (Programming)

- To setup NOTRACK and TRACK of conntrack in iptables (Linux)

- Use install_updates upgrade GAMIT / GLOBK (Linux)

- Linux Shell Understanding and Learning (Linux)

- VMware 8 installation configuration Win7, CentOS-7 Wizard (Linux)

- JQuery implements the same content merge cells (Programming)

- Arduino UNO simulation development environment set up and run simulation (Linux)

- How to create an alternative Android / iOS connected wireless hotspot AP in Ubuntu 15.04 (Linux)

- Linux Disk and File Management (Linux)

- Android Studio Getting Started Hello World (Programming)

- Linux in order to make NMAP hide and seek with the firewall (Linux)

- JBoss7 configuration - Supports IPv4 and IPv6 dual-stack environment (Server)

- The Linux disguised as windows to make the system more secure (Linux)

- STL in the list of erase () method (Programming)

- Linux system Iptables Firewall User Manual (Linux)

- Android memory optimization of the optimal load Bitmap (Linux)

- Linux iptables port mapping settings (Server)

- MySQL Tutorial: Philosophical Reflections on the unauthenticated user (Database)

- Type Linux commands (Linux)

- Android Studio and Git Git configuration file status (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:      
 
- Linux system monitoring, top command of the diagnostic tool Detailed (Linux)
- How to override the plain text files and directories soft connection in linux (Linux)
- imp / exp Oracle Database import and export commands (Database)
- OGG-01496 OGG-01031 Error Resolution (Database)
- Linux IPTables anti-DDOS attack Shell Scripting (Linux)
- Present Situation and Development Trend of firewall products (Linux)
- Python substring format (Programming)
- MySQLbinlog combat on using data recovery (Database)
- Linux source code analysis tool (Linux)
- ElasticSearch - Basic Concepts (Server)
- How to Install Winusb in Ubuntu 14.04 (Linux)
- Python 2.7.9 Installation on Linux CentOS 6.6 (Linux)
- To install Scribus 1.4.4 under ubuntu (Linux)
- Android will save the picture to see the album and timely (Programming)
- 10 tips daily Docker (Server)
- Zabbix monitoring of the switch (Server)
- Django1.5 Custom User Model (Programming)
- Linux environment SSH login password instead of using the RSA Certificate (Linux)
- Using 30 seconds to write a detailed analysis of garbage removal system (Linux)
- Setting Squid successful anti-hotlinking (Linux)
     
           
     
  CopyRight 2002-2016 newfreesoft.com, All Rights Reserved.