Home PC Games Linux Windows Database Network Programming Server Mobile  
  Home \ Database \ MySQL 5.6 database code changes     - Oracle to use full-text indexing (Database)

- Installation and operation GAMIT software under Linux operating system (Linux)

- Linux file system structure Introduction (Linux)

- Linux virtual machines to solve end MySQL database can not remote access (Database)

- Hackers is how the invasion and control of Things devices? (Linux)

- Update GAMIT10.6 command (Linux)

- pscp use Detailed Windows and Linux each file transfer tool (Linux)

- Setting up Linux machine through a proxy firewall (Linux)

- In-depth understanding of PHP ini configuration (Server)

- Simple solution CC attack under Linux VPS (Linux)

- PHP parsing algorithm of the interview questions (Programming)

- Ubuntu 14.04 to install Blender 2.71 (Linux)

- ORA-00600 error solve one case (Database)

- Installation and management of Linux applications (Linux)

- How to find an IP address through the command line (Linux)

- Use netcat [nc] command on Linux and Unix port scan (Server)

- Why did not Oracle privileges can also log in with sysdba (Database)

- DRBD + Heartbeat solve NFS single point of failure (Server)

- Manually generate AWR reports (Database)

- The difference between IPython and Python (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:

port = 3306
default-character-set = utf8

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.
- Redis-- persistence articles (Database)
- Linux Powerful command Awk Introduction (Linux)
- Ubuntu 14.04 forget solution root password (Linux)
- You know the difference between URL, URI and URN among you (Linux)
- DVD production using CentOS installation source within the company Yum (Linux)
- Fast Learning Clojure (Programming)
- How MAT Android application memory leak analysis (Programming)
- How to publish projects to the Jcenter repository using Gradle in Android Studio (Programming)
- CentOS7 compile and install Tengine + PHP + MariaDB notes (Server)
- Linux NIC driver and version information (Linux)
- How to install the Linux text editor Atom 0.124.0 (Linux)
- Ubuntu 14.04 running ASP.NET Configuration Mono + Jexus (Server)
- lack of SWAP space during installation of Oracle (Database)
- Install mono offline on CentOS (Server)
- Through eight skills to let you become a super Linux end-user (Linux)
- Installation GitLab appears ruby_block supervise_redis_sleep action run (Linux)
- MySQL how to export files with the date format (Database)
- Linux installed PCRE (Linux)
- Android determine the device network connection status, and determine the connection (Programming)
- Linux System Getting Started Learning: Linux in the last command (Linux)
  CopyRight 2002-2022 newfreesoft.com, All Rights Reserved.