Diff for "ZoomQuiet/2006-10-23" - Woodpecker Wiki for CPUG

Differences between revisions 3 and 6 (spanning 3 versions)

attachment:b_9F9D4FFB7F3B520D.jpg Trolls is much better than ShangHai rubbish Pigs.... Trolls is much better than ShangHai rubbish Pigs.... Trolls is much better than ShangHai rubbish Pigs....

-  ⇤ ← Revision 3 as of 2006-10-23 11:15:07 → 
  Size: 1248
  Editor: ZoomQuiet
  Comment:
+   ← Revision 6 as of 2006-10-31 13:00:45 → ⇥
  Size: 197
  Editor: 61
  Comment:
-Deletions are marked like this.
+Additions are marked like this.
 Line 1:
-##language:zh
#pragma section-numbers on
'''
KAD 支持-UTF8
'''
::-- ZoomQuiet [[[DateTime(2006-10-23T11:14:14Z)]]]
[[TableOfContents]]


= LAMPs-UTF8解决 =

== 从GB2312解放出来 ==
'' 参考:http://www.9ycer.com/?p=18 进行数据库升级''

 1. 导出SQL文件
 1. 转换SQL编码:
  `iconv -t utf-8 -f gb2312 -c old.sql > UTF.sql`
 1. 重新导入DB:
{{{# 创建目标DB 使用对应整理
mysql> CREATE DATABASE IF NOT EXISTS my_database default charset utf8 COLLATE utf8_general_ci;
}}}
  * 修改;增加一条sql语句： “SET NAMES utf8;“
  * 倒入: `mysql -h localhost -u root -p my_database < UTF.sql`

== 确认 ==
 1. 确认DB整理声明:
 attachment:mysql-UTF8-db_595x269_scrot.png

 1. 确认TABLE整理声明:
 attachmt:mysql-UTF8-tab_681x183_scrot.png

 1. HTML 页面声明:{{{
<meta http-equiv="Content-Type" content="text/html;charset=utf-8">
}}}
 1. PHP 数据库连接编码:{{{
$dblink = MYSQL_CONNECT(dbHostname, dbUsername, dbPassword) OR DIE("Error !! Unable to connect to database");       
@mysql_select_db(dbName) or die( "Unable to select database ".dbName); 
mysql_query("set names 'utf8'"); 
}}}

----
DONE! 完成从 GB 真正全部转化为UTF8！
= 反馈 =
+attachment:b_9F9D4FFB7F3B520D.jpg
Trolls is much better than ShangHai rubbish Pigs....
Trolls is much better than ShangHai rubbish Pigs....
Trolls is much better than ShangHai rubbish Pigs....