Ò»¸öÒ³ÃæÌá½»±íµ¥µ½servlet£¬ Õâ¸öservlet°ÑÊý¾Ý±£´æµ½MySQLÊý¾Ý¿âÖС£
Ìá½»±íµ¥µÄÒ³Ãæ²ÉÓÃutf-8Ò³Ãæ£¬ÎÄ×ÖÏÔʾÕý³£¡£ÔÚservletÖУ¬´ÓjspÒ³Ãæ´«¹ýÀ´µÄ²ÎÊý¾¹ýutf-8±àÂëת»»ÓÃSystem.out.println(²ÎÊý);Êä³öµ½Myeclipseºǫ́£¬ÏÔʾҲÊÇÕý³£¡£µ«ÊÇ·ÅÈëÊý¾Ý¿â ÀïÃæ¶¼ÊÇÂÒÂ룬 MySQL ×Ö·û¼¯Ò²ÊÇÉ趨Ϊutf-8£»
ÇëÖ¸½Ì£¡£¡
tomcatÖÐÉèÖÃÁËURIEncoding=¡°utf-8¡±ÁËÂð£¿
ÄãÁ¬½ÓÊý¾Ý¿âµÄURLÖ¸¶¨×Ö·û±àÂëΪUTF8û?
Èç¹ûÄãÊÇÔÚMYSQLµÄÃüÁîÐнçÃæ¿´µ½µÄÊÇÂÒÂë,ÄÇÊÇÒòΪÃüÁîÐеÄÏÔʾ×Ö·û±àÂë²»ÄÜÏÔʾÖÐÎÄ.
ÄãÔڲ鿴Êý¾ÝǰʹÓÃÃüÁî set names gbk;
È»ºóÔÙ²éÊý¾ÝÊÔÊÔ.Ó¦¸Ã¿ÉÒÔÁË.
Ò²¿ÉÒÔʹÓÃshow create table table_name À´²é¿´ÄãµÄ½¨±íÓï¾äÈ·¶¨ÎªUTF8
ÄãÓ¦¸ÃÏÈÔÚÂÛ̳ÉÏËÑË÷һϣ¬
¿´ÓÐûÓÐÏàͬµÄÎÊÌâ¼°½â¾ö°ì·¨ÔÙ·¢ÌûµÄ¡£
MySqlÂÒÂëÒ»¹²¿ÉÄÜÓÐÁ½Èý°Ù¸ö½á¹û!
ÒýÓà tomcatÖÐÉèÖÃÁËURIEncoding=¡°utf-8¡±ÁËÂ𣿠ÎÒÊÇÓÃÁ¬½Ó³Ø
<Resource name="jdbc/mysqlds"
driverClassName="com.mysql.jdbc.Driver"
url="jdbc:mysql://localhost:3306/crh?useUnicode=true&characterEncoding=UTF-8"
auth="Container"
type="javax.sql.DataSource"
maxActive="100"
maxIdle="30"
maxWait="10000"
username="root"
password="admin"
/>
ÒýÓÃ
ÎÒ¶ÔSQL SERVERºÍACCESS±È½ÏÊ죬ËùÒÔÊý¾Ý¿âµÄͨÓûù´¡¶«Î÷¿ÉÒÔ˵¶¼ÕÆÎյIJ¶àÁË£¬ÎÒÏÖÔÚÏëÒªµÄ¾ÍÊÇÒÔÉÏÁ½Êý¾Ý¿âµÄ¶ÀÌØÖ®´¦µÄ½éÉܺÍÓ¦ÓýéÉÜ¡£ ÁíÍâÊé×îºÃ¶ÔÓ¦×îа汾 oracleÊÇ11g°É 10µÄÒ²ÐУ»mysqlÊÇ5.1°É л ......
ÎÒµÄmysqlÔõôûÓа취дÈëÖÐÎÄÊý¾Ý£¿Ö»ÒªÊÇÊý¾ÝдÈëÊý¾Ý¿âʱ ¾Í»á±ä³ÉÈý¸öÎʺŠ£¿Çë½Ì¸ßÈË£¡£¡ linux? ÔõôдÈëµÄ ÔÚmysqlÖÐÖ´ÐÐ show variables like 'character%'Ìù½á¹û³öÀ´¡£ ÔÚ°²×°MYSLQʱ½«Êý¾Ý¿âµÄ×Ö· ......
ÔÚC++³ÌÐòÖÐͨ¹ýmysqlµÄC APIÖ±½ÓÁ¬½ÓÊý¾Ý¿â£¬µ±°ÑÖÐÎIJåÈëmysqlµÄʱºò£¬¾Í±ä³ÉÂÒÂëÁË. »¹ÓоÍÊÇʹÓÃload°ÑÎı¾Îļþµ¼ÈëmysqlÊý¾Ý¿â£¬ÎÞÂÛÎı¾ÎļþÊÇANSI±àÂ뻹ÊÇutf8±àÂ룬µ¼ÈëÖ®ºó¶¼ÊÇÂÒÂë¡£ ÆäÖÐmysqµÄ±àÂë¸ñʽ ......