mysqlÒ»¸öºÜÈÃÈ˲»½âµÄÎÊÌâ(¹ØÓÚ±àÂë)
ÎÒµÄweb³ÌÐòÊÇÕâÑùÉèÖÃµÄ jdbc:mysql://localhost:3306/lovedb?useUnicode=true&characterEncoding=utf8 Ò²¾ÍÊÇ˵ÎÒÊÇÅäÖóÉutf8µÄ... µ«ÊÇÔÚÊý¾Ý¿âÖÐ: set names 'uft-8'; select * from user_tb ;--------------------³öÀ´µÄ½á¹ûÊÇÂÒÂë. set names 'gb2312'; select * from user_tb ;--------------------³öÀ´µÄ½á¹ûÊÇÕýÈ·µÄ. ÎÒÃ÷Ã÷ÊÇÓÃutf-8д½øÈ¥µÄ..Ôõô»á±ä³Égb2312ÄØ,ÕæÊǹÖʰ¡
http://blog.csdn.net/ACMAIN_CHM/archive/2009/05/12/4174186.aspx MySQL ÖÐÎÄÏÔʾÂÒÂë ÒýÓà set names 'uft-8'; select * from user_tb ;--------------------³öÀ´µÄ½á¹ûÊÇÂÒÂë. Õâ¸öµÄÔÒòÊÇ¡£WINDOWS ÃüÁîÐУ¨Ò²¾ÍÊÇË׳ƵÄDOS£©ÎÞ·¨ÕýÈ·Ö§³ÖMYSQLÃüÁîÐÐÖеÄUTF8 àÅ£¬ÎÒµÄÊý¾Ý¿âÒ²ÊÇutf-8µÄ£¬phpµÄʱºòset names 'uft8';ÃüÁîÐеÄʱºòset names 'gb2312';
Ïà¹ØÎÊ´ð£º
ÎÒÒÔǰ°²×°ÁËÒ»´Î£¬ºóÀ´Ð¶ÔØÁË£¬ÏÖÔÚÔÙ°²×°µÄʱºò£¬Ìáʾ´íÎó£ºError 1305.Error reading from file C:DOCUME~1\LOCALS~1\Temp\mysql_server.msi.Verify that the file exists and that you can access it. ¿ ......
ÎÒÒÔǰ°²×°ÁËÒ»´Î£¬ºóÀ´Ð¶ÔØÁË£¬ÏÖÔÚÔÙ°²×°µÄʱºò£¬Ìáʾ´íÎó£ºError 1305.Error reading from file C:DOCUME~1\LOCALS~1\Temp\mysql_server.msi.Verify that the file exists and that you can access it. ¿ÉÊÇÎÒÕÒ ......
ÎÒ¶ÔSQL SERVERºÍACCESS±È½ÏÊ죬ËùÒÔÊý¾Ý¿âµÄͨÓûù´¡¶«Î÷¿ÉÒÔ˵¶¼ÕÆÎյIJ¶àÁË£¬ÎÒÏÖÔÚÏëÒªµÄ¾ÍÊÇÒÔÉÏÁ½Êý¾Ý¿âµÄ¶ÀÌØÖ®´¦µÄ½éÉܺÍÓ¦ÓýéÉÜ¡£ ÁíÍâÊé×îºÃ¶ÔÓ¦×îа汾 oracleÊÇ11g°É 10µÄÒ²ÐУ»mysqlÊÇ5.1°É л ......
ÎÒµÄmysqlÔõôûÓа취дÈëÖÐÎÄÊý¾Ý£¿Ö»ÒªÊÇÊý¾ÝдÈëÊý¾Ý¿âʱ ¾Í»á±ä³ÉÈý¸öÎʺŠ£¿Çë½Ì¸ßÈË£¡£¡ linux? ÔõôдÈëµÄ ÔÚmysqlÖÐÖ´ÐÐ show variables like 'character%'Ìù½á¹û³öÀ´¡£ ÔÚ°²×°MYSLQʱ½«Êý¾Ý¿âµÄ×Ö· ......
¸Õ°²×°mysqlµÄʱºò£¬°Ñ³õʼÃÜÂëÍü¼ÇÁË£¬Ö»ºÃÌø¹ýȨÏÞÑéÖ¤£¬ÐÞ¸ÄÃÜÂ룬Ð޸ijɹ¦ºó£¬ÄܵǼ£¬¿ÉÊÇ»úÆ÷ÖØÆôÁË£¬ÓøĹýµÄÃÜÂëÓֵDz»ÉÏÁË£¬ÏÂÎÄÊÇÐ޸ĵķ½·¨£¬²»ÖªµÀÄÄÀï³öÁËÎÊÌ⣿ ÃÜÂëÐ޸ķ½·¨£º 1.ÒÔϵͳ¹ ......