http://www.larryullman.com/forums/index.php?/topic/433-setting-up-mercury-mail-with-xampp/
How to set up Mercury email server within xampp?
How to add email accounts?
How to send an email from PHP?
14 February 2013
23 January 2013
09 January 2013
01 January 2013
MySQL does not display Chinese
NOTE: Generally, 3 places - (1) When creating a database, you should include character set; (2) In head section of html code of a web page, you should define character set; (3) after mysql_select_db, you should include mysql_query("set names gbk;"). That is all.
(1) In the file 'my.ini', add the following two lines:
[client]
default-character-set=gbk
[mysqld]
character-set-server=gbk
Restarted MySQL server.
(2) When creating a database, use -
create database [database name] character set 'gbk' collate 'gbk_chinese_ci';
(3) Run the command 'show create table ...'.
mysql>show create table [table name];
Check what the default default charset is.
If it is not 'gbk', change it into 'gbk'.
The method is -
create table if not exists '[table name]' (
...
) engine=InnoDB default charset=gbk;
(4) In the PHP page, after the statement -
mysql_select_db("dbname", $db);
Add the following statement -
mysql_query("set names gbk;");
After the above 3 actions, Chinese will be displayed.
(1) In the file 'my.ini', add the following two lines:
[client]
default-character-set=gbk
[mysqld]
character-set-server=gbk
Restarted MySQL server.
(2) When creating a database, use -
create database [database name] character set 'gbk' collate 'gbk_chinese_ci';
(3) Run the command 'show create table ...'.
mysql>show create table [table name];
Check what the default default charset is.
If it is not 'gbk', change it into 'gbk'.
The method is -
create table if not exists '[table name]' (
...
) engine=InnoDB default charset=gbk;
(4) In the PHP page, after the statement -
mysql_select_db("dbname", $db);
Add the following statement -
mysql_query("set names gbk;");
After the above 3 actions, Chinese will be displayed.
30 December 2012
I have inserted Chinese characters into my MySQL table. Why does SELECT display them as “?” characters?
http://dev.mysql.com/doc/refman/5.0/en/faqs-cjk.html#qandaitem-B-11-1-2
It does not display Chinese on a web page
<head>
<meta http-equiv="content-type" content="charset=gb2312" />
</head
<meta http-equiv="content-type" content="charset=gb2312" />
</head
Subscribe to:
Posts (Atom)