注册 登录
编程论坛 MySQL论坛

ph与mysql汉字显示问题

95nh 发布于 2007-04-24 21:19, 2050 次点击
mysql中默认字符设置为GB2312,与php也能够连接起来,但在网页的显示中却提示:??。数据库中汉字数据显示不正常。如果把mysql 中的默认字符设置成utf8,在mysql提示符下,不能输入汉字数据,但是通过网页设计,在IE中可以输入汉字,调用数据库,在IE上显示汉字正常,但在mysql提示符下,却显示不正常,请教如何解决这种问题(汉字输入与汉字显示的问题)。
6 回复
#2
lmhllr2007-04-24 23:33

提示符下先执行set names 'gb2312'

#3
kidy20052007-05-05 14:29
那我要是使用phpMyAdmin来操作数据库,怎么解决汉字问题啊?
#4
lmhllr2007-05-05 14:31
似乎PHPMYADMIN默认是UTF8的

整理一下连接字符集应该能解决
#5
kidy20052007-05-05 15:00
要整理成哪种字符集才可以啊?我是新手,我不会啊,请多指教啊,谢谢!
#6
kidy20052007-05-05 15:02

是gbk还是gb2312啊?

#7
kidy20052007-05-05 15:04

dijie! info: MySQL Query Error

Time: 2007-5-5 7:04am
Script: /cngmest/index.php

SQL: insert into t_carttemp ( strSessionID, intUserID, intGameID, intServerID, strServer, strCareer, intProductID, strName, intStart, intEnd, intQuanPer, strUnit, dblPrice, strUserName, strPassword, strComments, intType, intQuan, strTime, strCharacter, blnStock, dtAddDate, blnDelete, strLocationItem )values( '1178339129BU7ICK', '0', '1', '116', 'Zuluhed-H', '', '1', '50 G', 0, 0, '50', 'G', '10.02', '', '', '', '1', '1', 24小时内, '1', '', '1178348643', 0 , '通过客服' )
Error: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '? '1', '', '1178348643', 0 , '通过客服' )' at line 1
Errno.: 1064

An error report has been dispatched to our administrator.


如何解决上面这个问题啊?

1