[FZH] mysql 字符编码问题
cheng chen
freakrobot在acm.org
星期一 五月 31 09:39:26 UTC 2010
2010/5/31 Lemon <lemon027在gmail.com>
>
> ÔÀ´µÄÒ»¸öʵÑéÊÒµÄС¹ÜÀíϵͳ£¬Êý¾ÝÊÇÓÃgb2312¼ÈëµÄ£¬ÏÖÔÚÏëµ¼³öÊý¾ÝÓÃÓÚÁíÍâÒ»¸öÊý¾Ý¿â¡£¿ÉÊDz»ÂÛ´ÓÖն˵Ǽ»¹ÊÇphpmyadminµÇ¼¶¼ÊÇÂÒÂ룬ÓÐûÓнâ¾ö·½°¸£¿
>
>
Èç¹ûÓÃÓïÑÔµÄapiµÄ»°ºÃÏñÊÇÁ¬½ÓÊý¾Ý¿âÒÔºó¼ÓÒ»¾ä£º¡°mysql_query("set names gb2312")¡±
Èç¹ûÊǵ¼Èëµ¼³öÄã¿´¿´±íµÄ±àÂ뼯¶Ô²»¶Ô£º
±ÈÈ磺
CREATE DATABASE `bankmanage` DEFAULT CHARACTER SET utf8 COLLATE
utf8_general_ci;
USE `bankmanage`;
CREATE TABLE IF NOT EXISTS `account` (
`aid` bigint(11) NOT NULL AUTO_INCREMENT,
`uid` varchar(20) NOT NULL,
`password` varchar(256) NOT NULL,
`money` bigint(11) NOT NULL DEFAULT '0',
`create_date` date NOT NULL,
`lost` int(11) NOT NULL DEFAULT '0',
PRIMARY KEY (`aid`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=6222003202100000009 ;
> --
> There are only 10 types of people in the world, those who understand binary
> and those who don't.
>
> --
> (This is Carbon Copied from legacy mailing list fedora-cn在googlegroups.com
> .)
> _______________________________________________
> Chinese mailing list
> Chinese at lists.fedoraproject.org
> https://admin.fedoraproject.org/mailman/listinfo/chinese
>
--
Cheng(Õ\)
Fedora User
My Page: http://scienologies.blogspot.com
http://gnudam.webgarden.com
Fedora Project Contributor -- Ambassador
https://fedoraproject.org/wiki/User:Freakrobot
_______________________________________________
Chinese mailing list
Chinese at lists.fedoraproject.org
https://admin.fedoraproject.org/mailman/listinfo/chinese
--
(This is Carbon Copied from legacy mailing list fedora-cn在googlegroups.com.)
关于邮件列表 Chinese 的更多信息