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     - Hadoop new and old version of the difference in the size of the InputSplit (Server)

- Ubuntu 12.04 kernel configuration automatically restart and crash dump (Linux)

- Oracle Execute to Parse perform analytical Ratio Analysis (Database)

- CentOS iptables firewall enabled (Linux)

- Nine tips to protect the security of Linux desktop (Linux)

- grep command Series: How to Use the grep command in Linux / UNIX (Linux)

- Ubuntu install virtual machine software VirtualBox 4.3.10 (Linux)

- CentOS 7 How to connect to a wireless network (Linux)

- How do I cancel (almost) any operations in Git, (Linux)

- impdp error ORA-31631, ORA-39122 (Database)

- The Hill sorting algorithm (Programming)

- OpenGL ES 3.0 vertex buffer (Programming)

- Tmux create the perfect terminal management tool under CentOS (Linux)

- Linux file permissions chmod chown (Linux)

- Python2 ---- function using dictionaries (Programming)

- Oracle Linux 5.9 configuration Xmanager (Linux)

- Ubuntu installation 2.10.x version of Scala (Linux)

- Upgrading Oracle 11.2.0.1.0 to 11.2.0.3.0 (Database)

- Ubuntu 10.04 to Ubuntu 10.10 Upgrade (Linux)

- Install Ubuntu text editor KKEdit 0.2.10 (Linux)

 
         
  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:      
 
- Nginx-1.9.7 TCP reverse proxy (Server)
- Oracle 11gr2 new APPEND_VALUES tips (Database)
- CentOS achieve trash mechanism (Linux)
- Linux Getting Started tutorial: build your own Vim (Linux)
- WordPress plug-ins installed in Ubuntu, enter the subject of FTP and not create directory problem (Server)
- Thinking in Java study notes - Access modifiers (Programming)
- Linux, how to filter, split, and merge pcap file (Linux)
- Use the Find command to help you find those files that need to be cleaned (Linux)
- PLSQL Developer synchronization table tools (Database)
- linux network security experience (Linux)
- MongoDB3.0.6 wiredtiger MMAPv1 (Database)
- Installation Experience open source car Automotive Grade Linux system (Linux)
- Ubuntu 14.04 configure JDK1.8.0_25, switchable version (Linux)
- Linux installation beautify early experience (Linux)
- 10 Nginx safety tips (Linux)
- Depth study and understanding for individual users suicide DDoS attacks (Linux)
- Java 8 perspective annotation types (Programming)
- CentOS 6.5 installation and deployment SVN 1.8.10 (Linux)
- Setting grep Highlight Matches (Linux)
- Linux Tutorial: Open multiple tabs in the GNOME terminal in Ubuntu 15.04 (Linux)
     
           
     
  CopyRight 2002-2022 newfreesoft.com, All Rights Reserved.