生僻字无法写入。三大字符集都试过了,不是空白就是问号
my.ini 的相关内容(我只改了这两个)[mysql]
default-character-set=gb2312[mysqld]
default-character-set=gb2312
1:两个值都改成gb2312:
set names gb2312;
update myuser set user_name='劼' where user_id=1;
结果内容是空的2:两个值都改成utf8:
set names utf8;
update myuser set user_name='劼' where user_id=1;
结果内容是问号:?
3:两个值都改成gbk:
set names gbk;
update myuser set user_name='劼' where user_id=1;
结果内容是问号:?
请问各位这是怎么回事啊?要怎么解决呢?
my.ini 的相关内容(我只改了这两个)[mysql]
default-character-set=gb2312[mysqld]
default-character-set=gb2312
1:两个值都改成gb2312:
set names gb2312;
update myuser set user_name='劼' where user_id=1;
结果内容是空的2:两个值都改成utf8:
set names utf8;
update myuser set user_name='劼' where user_id=1;
结果内容是问号:?
3:两个值都改成gbk:
set names gbk;
update myuser set user_name='劼' where user_id=1;
结果内容是问号:?
请问各位这是怎么回事啊?要怎么解决呢?
default-character-set=gb2312 [mysqld]
default-character-set=gb2312 ====================================
上面是一样的,然后建立数据库的时候这样create table description (
name VARCHAR(16),
description VARCHAR(32)
)default charset=gb2312;
然后正常插入数据就可以了
如: insert into description values('1', '普通用户');
试试看?
default-character-set=gb2312 [mysqld]
default-character-set=gb2312
平时最好设置成urf8
在PHP调用的时候请使用@mysql_query("SET character_set_connection=utf8, character_set_results=utf8, character_set_client=binary");