Home Database Mysql Tutorial MySQL5字符集问题的解决方案

MySQL5字符集问题的解决方案

Jun 07, 2016 pm 02:52 PM
introduce character set article solution

以下的文章主要是介绍一种更为快捷的方法来实现MySQL5字符集问题,以下就是MySQL5字符集问题与其实际解决办法的描述,希望在你今后的学习中会有所帮助。希望你浏览之后能有所收获。 今天打开slave日志发现一堆错误全部是这种: [ERROR] Slave: Error 'Charac

  以下的文章主要是介绍一种更为快捷的方法来实现MySQL5字符集问题,以下就是MySQL5字符集问题与其实际解决办法的描述,希望在你今后的学习中会有所帮助。希望你浏览之后能有所收获。

  今天打开slave日志发现一堆错误全部是这种:

  [ERROR] Slave: Error 'Character set '#28' is not a compiled character set and is not specified in the '/usr/local/MySQL(和PHP搭配之最佳组合)/share/MySQL(和PHP搭配之最佳组合)/charsets/Index.xml(标准化越来越近了)' file' on query.

  我在master(linux)机上写insert语句,发现同步是没问题的,后来我在window上用一个MySQL(和PHP搭配之最佳组合)客户端插入数据,上面的问题就开始出现了。通过MySQL(和PHP搭配之最佳组合)binlog查看slave日志发现

  如果使用gbk编码的客户端插入数据就会有下面的日志:

  SET @@session.character_set_client=28,@llation_connection=33,@llation_server=8/*!*/; 

  如果是直接在linux写insert,那么上面的28(gbk) 就变成8(latin-swde)

  原因应该是MySQL(和PHP搭配之最佳组合)客户端使用了gbk编码,而服务器无法识别。虽然你可以在'/usr/local/MySQL(和PHP搭配之最佳组合)/share/MySQL(和PHP搭配之最佳组合)/charsets/Index.xml(标准化越来越近了)' 找到gbk,但通过 SHOW CHARACTER SET;确实可以看出数据库没有列出gbk。

  我又比较了一下别的机器上的MySQL(和PHP搭配之最佳组合)版本,发现那些机器上的MySQL(和PHP搭配之最佳组合)都是用的发布版本,而这台slave机使用源代码安装的,于是我下了个MySQL5字符集(和PHP搭配之最佳组合)-5.0.37-linux-i686-glibc23.tar.gz

  然后

  cd /usr/local

  mv MySQL(和PHP搭配之最佳组合) MySQL(和PHP搭配之最佳组合)-old

  tar xzvf MySQL(和PHP搭配之最佳组合)-5.0.37-linux-i686-glibc23.tar.gz

  mv MySQL(和PHP搭配之最佳组合)-5.0.37-linux-i686-glibc23 MySQL(和PHP搭配之最佳组合)

  启动MySQL(和PHP搭配之最佳组合),一切就ok了

  MySQL5字符集

  以上的相关内容就是对MySQL5字符集问题以及解决办法的介绍,望你能有所收获。

Statement of this Website
The content of this article is voluntarily contributed by netizens, and the copyright belongs to the original author. This site does not assume corresponding legal responsibility. If you find any content suspected of plagiarism or infringement, please contact admin@php.cn

Hot Article Tags

Notepad++7.3.1

Notepad++7.3.1

Easy-to-use and free code editor

SublimeText3 Chinese version

SublimeText3 Chinese version

Chinese version, very easy to use

Zend Studio 13.0.1

Zend Studio 13.0.1

Powerful PHP integrated development environment

Dreamweaver CS6

Dreamweaver CS6

Visual web development tools

SublimeText3 Mac version

SublimeText3 Mac version

God-level code editing software (SublimeText3)

Solution for Win11 unable to install Chinese language pack Solution for Win11 unable to install Chinese language pack Mar 09, 2024 am 09:15 AM

Solution for Win11 unable to install Chinese language pack

How can I make money by publishing articles on Toutiao today? How to earn more income by publishing articles on Toutiao today! How can I make money by publishing articles on Toutiao today? How to earn more income by publishing articles on Toutiao today! Mar 15, 2024 pm 04:13 PM

How can I make money by publishing articles on Toutiao today? How to earn more income by publishing articles on Toutiao today!

An effective solution to solve the problem of garbled characters caused by Oracle character set modification An effective solution to solve the problem of garbled characters caused by Oracle character set modification Mar 03, 2024 am 09:57 AM

An effective solution to solve the problem of garbled characters caused by Oracle character set modification

Oracle NVL function common problems and solutions Oracle NVL function common problems and solutions Mar 10, 2024 am 08:42 AM

Oracle NVL function common problems and solutions

Implementing Machine Learning Algorithms in C++: Common Challenges and Solutions Implementing Machine Learning Algorithms in C++: Common Challenges and Solutions Jun 03, 2024 pm 01:25 PM

Implementing Machine Learning Algorithms in C++: Common Challenges and Solutions

Common causes and solutions for Chinese garbled characters in MySQL installation Common causes and solutions for Chinese garbled characters in MySQL installation Mar 02, 2024 am 09:00 AM

Common causes and solutions for Chinese garbled characters in MySQL installation

Introduction to the skills and attributes of Hua Yishan Heart of the Moon Lu Shu Introduction to the skills and attributes of Hua Yishan Heart of the Moon Lu Shu Mar 23, 2024 pm 05:30 PM

Introduction to the skills and attributes of Hua Yishan Heart of the Moon Lu Shu

Can't boot after Win11 upgrade? Try these solutions! Can't boot after Win11 upgrade? Try these solutions! Mar 08, 2024 pm 03:39 PM

Can't boot after Win11 upgrade? Try these solutions!

See all articles