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     - Paint with Vim (Linux)

- Zabbix API and PHP configuration (Server)

- How to choose the correct HTTP status code (Server)

- Steps to build MPICH2 development environment on CentOS 6.4 (Linux)

- Comparison of C # and Java (Programming)

- Ubuntu 12.04 / 14.04 users to install software LyX document processing (Linux)

- CentOS 6.5 installation and simple configuration Nginx (Server)

- Oracle 11g user rights management study notes (Database)

- Using Libreoffice under ubuntu (Linux)

- MySQL Parameter Tuning Best Practices (Database)

- Ubuntu 14.04 next upgrade to GNOME 3.12 (Linux)

- DM9000 bare Driver Design (Programming)

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

- Debian (Wheezy) Install Java environment / replace OpenJDK as the SUN JDK (Linux)

- ISO image to use offline upgrade Ubuntu (Linux)

- Linux Firewall Builder shorewall (Linux)

- Install Java JDK 8 in CentOS 7 / 6.5 / 6.4 (Linux)

- Java inner classes (Programming)

- Valgrind * not * leak check tool (Linux)

- MongoDB replication instance (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:      
 
- Docker command Detailed (Linux)
- The callback function used in C ++ (Programming)
- Relationship between Linux permissions with the command (Linux)
- How to install the Ruby runtime environment on Mac OS X (Linux)
- Java executable file to read information from a database copy (Programming)
- Iptables use examples (Linux)
- C ++ inheritance and derived (induction principle) (Programming)
- WebLogic administrator account and reset the password (Database)
- Linux md5sum verify file integrity (Linux)
- Using C / C ++ extensions Python (Programming)
- Oracle 11g + RAC + RHEL6.5 + udev + ASM + PSU installation summary (Database)
- Detailed reference Oracle 11g Partition (Database)
- Oracle set the timer task JOB scheduler to execute stored procedures or PL / SQL code block (Database)
- Experience CoreCLR stack unwinding characteristics of initial implementation on Linux / Mac (Linux)
- Linux create and delete user step (Linux)
- MySQL 5.7.9 source compiler installation instructions (Database)
- Ubuntu Apache2 setting, problem solving css, pictures, etc. can not be displayed (Server)
- Can not remember how to solve the problem under Ubuntu brightness setting (Linux)
- Process safety monitoring and protection under the Linux operating system (Linux)
- Security Knowledge: How to hide a backdoor PHP file tips (Linux)
     
           
     
  CopyRight 2002-2022 newfreesoft.com, All Rights Reserved.