Home > Database > Mysql Tutorial > Ubuntu 12.04设置MySQL的默认编码

Ubuntu 12.04设置MySQL的默认编码

WBOY
Release: 2016-06-07 17:21:01
Original
1200 people have browsed it

虽然说Ubuntu不折腾几次分区不算用过,但是真的折腾起来费时费力,我的笔记本分区情况,由于我主要在ubuntu下做开发,所以我装了

(1)唉,系统装了一天,虽然说Ubuntu不折腾几次分区不算用过,但是真的折腾起来费时费力

(2)说一下,我的笔记本分区情况,由于我主要在ubuntu下做开发,所以我装了双系统,windows主要是为了玩游戏的,大家都懂得,不多说了。ubuntu的分区规划是:/boot 256M /swap  8G  /home 120G  /root 50G

(3)主要是在ubuntu12.04下设置mysql编码出现了一点bug,和之前11.10以及之前的版本稍有差别,差别如下:

之前的10.04配置如下:

[client]

default-character-set = utf8

[mysqld]

default-character-set = utf8

但是12.04修改了设置mysqld的编码方法:


[client]

default-character-set = utf8 (ps:client的设置没变)

[mysqld]

lower_case_table_names = 1 (不区分大小写)

character_set_server = utf8 (ps:注意这里的改动)

(4)在ubuntu下,中文输入法一直都是个问题,建议还是用fcitx吧,ibus不习惯。

linux

Related labels:
source:php.cn
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
Popular Tutorials
More>
Latest Downloads
More>
Web Effects
Website Source Code
Website Materials
Front End Template