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     - Under CentOS using yum command to install the Task Scheduler crontab (Linux)

- Shell for loop (Programming)

- Default permissions Linux file and directory permissions and hide - umask, chattr, lsattr, SUID, SGID, SBIT, file (Linux)

- Git Experience Sharing - Using a remote repository (Linux)

- GitLab installation configuration notes (Linux)

- On FreeBSD 10.2 Bugzilla how to install and configure Apache SSL (Server)

- Hyper-V virtual hard disk how to copy files to and attached to the virtual machine (Linux)

- How to use the TF / SD card making Exynos 4412 u-boot boot disk in Ubuntu (Linux)

- XenServer virtual machines installed in dual-card configuration (Server)

- To install MySQL 5.6 binary packages under CentOS 6.4 64bit (Database)

- Summary Linux bond of multi-interface load balancing (Linux)

- How to use the TF / SD card making Exynos 4412 u-boot boot disk in Mac (Linux)

- The relationship between UNIX and Linux (Linux)

- Let the terminal under Mac OS X as like Linux has displayed a variety of colors (Linux)

- Python regular expressions: how to use regular expressions (Programming)

- Erlang concurrency and foundation (Programming)

- Under Ubuntu on how to use iptables firewall (Linux)

- How to install Wine 1.7.20 under Ubuntu or Linux Mint (Linux)

- The hash function under OpenSSL (Linux)

- MongoDB query statistics grouping remove duplicate records (Database)

 
         
  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

mistake.

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
     
         
         
         
  More:      
 
- Atheros AR8161 / AR8162 network card driver problem solving in CentOS 6.4 (Linux)
- CentOS 6.5 / Linux restart network card being given Determining if ip address x.x.x.x is already in use (Linux)
- Oracle GoldenGate tutorial Second, configure and use (Database)
- Find details block device with Linux blkid command (Linux)
- Linux System Getting Started Learning: The Linux anacron command (Linux)
- Analysis of Java exception (Programming)
- Construction of Android and iOS apps use Jenkins Automation (Programming)
- The basic principles for the protection of a good linux server security (Linux)
- linux firewall configuration (Linux)
- About Git (Linux)
- How to install or upgrade to the Linux kernel in Ubuntu 4.2 (Linux)
- Oracle Data Pump Example (Database)
- stat - Get more information than ls (Linux)
- How x2go set up Remote Desktop on Linux (Linux)
- Red Hat Enterprise Linux Server 6.5 installation GCC 4.9.2 (Linux)
- The Objects in JavaScript (Programming)
- Monitor traffic Linux Shell Edition (Programming)
- Docker + Nginx + Tomcat7 simple load balancing configuration (Server)
- Setting CentOS firewall open port (Linux)
- MySQL uses Federate engine mapping table to achieve operation of the local remote operation table (Database)
     
           
     
  CopyRight 2002-2022 newfreesoft.com, All Rights Reserved.