Home PC Games Linux Windows Database Network Programming Server Mobile  
  Home \ Database \ MySQL appears data too long for column 'name' at row 1 to solve     - About the replication of JavaScript (Programming)

- Character Encoding notes: ASCII, Unicode and UTF-8 (Linux)

- Install Redis 2.6 5.5 32 position CentOS error resolved (Linux)

- Improve the Ubuntu SSH login authentication approach speed (Linux)

- Let Markdown code syntax highlighting and support Django1.6 (Linux)

- Linux using RAID how to use Mdadm Tool Management Software RAID (Linux)

- RedHat install GCC problem --- Depends (Linux)

- MySQL Tutorial: Using tpcc-mysql pressure measurement (Database)

- JDK installation under CentOS (Linux)

- Spark source code compiler package (Linux)

- Some common Linux commands Study Notes (Linux)

- CentOS7 installed MySQL (Database)

- Sniffer install applications in Linux supplement (Linux)

- Job achieve automation in Ubuntu 14.04 - Using Cron (Linux)

- tar command to extract a file error: stdin has more than one entry (Linux)

- Mount and unloading disks under Linux (Linux)

- Java keyword final, static (Programming)

- Zypper command for SUSE Linux package management (Linux)

- HBase table data processing tab (Database)

- ASP.NET 5 tutorial series (Server)

  MySQL appears data too long for column 'name' at row 1 to solve
  Add Date : 2018-11-21      
  1, phenomenon: we set the database character set encoding when utf-8, we insert a column to a table of other language characters by DOS interface to encounter similar

data too long for column 'name' at row 1


2, the cause:

variable_name value
charachter_set_client utf8

3, the solution:

(1) set names utf8; (only valid for the current window)

(2) find the mysql installation directory, the file is my.ini in the "default-character-set = " changed to "default-character-set = utf8", and then restart the mysql service
- What is Java EE (Programming)
- Oracle 11R2 Grid Infrastructure execute root.sh script rootcrs.pl execution failed treatment (Database)
- How to use the command line ftp upload and download files (Linux)
- error no.2013 lost connection Tom with SQLServer during query (Database)
- Testing Oracle 11g RMAN replicate database (Database)
- Increase Linux system security --chattr (Linux)
- To install the latest version of the EPEL on CentOS 5.x or 6.x (Linux)
- Log device files under Linux - logger (Linux)
- Access.log Apache access log analysis and how to import it into MySQL (Server)
- MySQL use benchmarking tool sysbench (Database)
- Android Studio quick overview of Gradle (Programming)
- SSH without password (Linux)
- How to generate Linux, random password encryption or decryption (Linux)
- Node.js developers must know four JavaScript concepts (Programming)
- MySQL performance comparison of large amounts of data storage (Database)
- C # compiler to achieve functional use in the runtime (Programming)
- CentOS achieve trash mechanism (Linux)
- Linux, Apache Web site security settings (Linux)
- JavaScript basic tools list (Programming)
- High-performance JavaScript loops and flow control (Programming)
  CopyRight 2002-2022 newfreesoft.com, All Rights Reserved.