同一个数据库,表的编码都是utf8的,在navicat下(encoding选择utf8)看都是正确的,但是用JDBC连,一个表是正确的中文,一个表却是乱码..无语了..不知道什么原因..每个字段都是UTF8的.
useUnicode=true&characterEncoding=utf8 ,JDBC都是这么连的.\....
useUnicode=true&characterEncoding=utf8 ,JDBC都是这么连的.\....
看看这个也许能解决你的问题。http://blog.csdn.net/guoguo1980/archive/2006/07/22/961046.aspx
{
// check mysql version first.
$serverVersion = mysql_get_server_info($this->dbh);
$version = explode('.', $serverVersion);
if ($version[0] < 4) return; // check if utf8 support was compiled in
$result = mysql_query("SHOW CHARACTER SET like 'utf8'",
$this->dbh);
if (mysql_num_rows($result) < = 0) return;if ($charset == 'utf-8' || $charset == 'UTF-8')
$charset = 'utf8';
@mysql_query("SET NAMES '$charset'", $this->dbh);
}在 wp-settings.php 的 require (ABSPATH . WPINC . '/vars.php'); 后增加: $wpdb->set_charset(get_bloginfo('charset'));
Trackback: http://tb.blog.csdn.net/TrackBack.aspx?PostId=961046