Ò׽ؽØÍ¼Èí¼þ¡¢µ¥Îļþ¡¢Ãâ°²×°¡¢´¿ÂÌÉ«¡¢½ö160KB

ʹÓÃMYSQLÊý¾Ý¿â²åÈëͼƬʱ¹ØÓÚÊý¾Ý¿â×Ö·û¼¯µÄ´íÎó

 ÔÚʹÓÃJDBC²Ù×÷Êý¾Ý¿â ÔÚÏòÊý¾Ý¿âÖвåÈëͼƬʱ£¬³ÌÐòÀÏÊÇÅ×Òì³£
Ô­À´µÄMYSQL×Ö·û¼¯ÊÇGBK  µ«ÊÇÕâÖÖ×Ö·û¼¯ËäȻ֧³ÖÖÐÎÄ µ«Êǵ±²åÈëͼƬµÈ¶þ½øÖÆÊý¾Ýʱ »á³öÏÖ´íÎó
½â¾ö·½·¨£º
½«Êý¾Ý¿â×Ö·û¼¯¸ü¸ÄΪgb2312»òutf-8
1.ÔÚMYSQL DOS½çÃæÖÐÊäÈë  show  variables  like "%char%";
+--------------------------+---------------+   
| Variable_name                 | Value         |   
+--------------------------+---------------+   
| character_set_client          | latin1        |   
| character_set_connection | latin1        |   
| character_set_database    | latin1        |   
| character_set_filesystem   | binary       |   
| character_set_results        | latin1        |   
| character_set_server         | latin1        |   
| character_set_system        | utf8          |   
+--------------------------+---------------+
1
¡¢ÐÞ¸ÄÊý¾Ý¿âĬÈÏ×Ö·û¼¯£º
´ò¿ªC:\Program Files\MySQL\MySQL Server 5.0
ÀïÃæµÄmy.ini
ÎļþÕÒµ½Õâ¶ÎÎÄ×Ö£º
ÒýÓÃ
# The default character set that will be used when a new schema or table is
# created and no character set is defined
default-character-set=latin1

°Ñdefault-character-set=latin1
¸ÄΪdefault-character-set=gb2312
 
2
¡¢Èç¹ûÄãÊǵ¼ÈëµÄÊý¾Ý¿â£¬ÐèÒª¶Ômy.ini
×öÈçÏÂÐÞ¸ÄÕÒµ½
ÒýÓÃ
[client


Ïà¹ØÎĵµ£º

linux·þÎñÆ÷ÓÃlighttpd+mysql5+php5+SupeSite/X

Ò»¡¢°²×°ÏµÍ³»·¾³
1¡¢ÏµÍ³£ºcentos5
2¡¢²âÊÔÔÚvm5.5
×¼±¸Èí¼þ
lighttpd-1.4.18
ÏÂÔØµØÖ·
mysql-5.0.41
part1ÏÂÔØµØÖ·
part2ÏÂÔØµØÖ·
part3ÏÂÔØµØÖ·
php-5.2.3
ÏÂÔØµØÖ·
SupeSite/X-Space
part1ÏÂÔØµØÖ·
part2ÏÂÔØµØÖ·
part3ÏÂÔØµØÖ·
discuz
ÏÂÔØµØÖ·
¶þ¡¢´î½¨web·þÎñÆ÷°²×°¹ý³Ì
1¡¢mysql5°²×°
$ tar zx ......

PenroseÁ¬½ÓMysql½â¾ö·½°¸

 ×î½üÒ»Ö±ÔÚ½øÐÐPenroseÁ¬½ÓMysqlµÄ³¢ÊÔ£¬¿É×ÜÊÇÌáʾÎÞ·¨Á¬½Óµ½Mysql£¬ÎÞÂÛÊǼì²é¶Ë¿ÚÊÇ·ñ¿ªÆô£¬ÉèÖÃMysqlÔ¶³Ì·ÃÎÊȨÏ޵ȶ¼²»¹ÜÓ㬺óÀ´ÔÚPenroseµÄ¹ÙÍøÕÒµ½Ò»¸ö½¨Á¢ÑùÀýÊý¾Ý¿â¼°ÉèÖÃÔ¶³ÌÁ¬½ÓµÄÎĵµ£¬Ã»Ïëµ½Ò»¾Ù³É¹¦£¬Í´¿ì°¡£¡
ÏÂÃæ¾Í°ÑÎĵµºÍ´ó¼Ò¹²Ïíһϣ¡£¨ÊÇÓ¢ÎÄ£¬´ó¼Ò¾Í´ÕºÏ×Å¿´Ï°ɣ¡ÒòΪ×î½ü¸ãPenroseÌ«ÀÛÁË£¬ ......

mysqlµÄ×Ö·û´®º¯Êý

¶ÔÓÚÕë¶Ô×Ö·û´®Î»ÖõIJÙ×÷£¬µÚÒ»¸öλÖñ»±ê¼ÇΪ1¡£
ASCII(str) ·µ»Ø×Ö·û´®strµÄ×î×óÃæ×Ö·ûµÄASCII´úÂëÖµ¡£Èç¹ûstrÊÇ¿Õ×Ö·û´®£¬·µ»Ø0¡£Èç¹ûstrÊÇNULL£¬·µ»ØNULL¡£
mysql> select ASCII('2');
-> 50
mysql> select ASCII(2);
-> 50
mysql> select ASCII('dx');
-> 100
Ò² ......

ʹÓÃWAMP5´î½¨Apache+MySQL+PHP»·¾³

 Ä¿Ç°Óв»ÉÙAMP£¨Apache\MySQL\PHP£©µÄ¼¯³ÉÈí¼þ£¬¿ÉÒÔÈÃÎÒÃÇÒ»´Î°²×°²¢ÉèÖúá£Õâ¶ÔÓÚ²»ÊìϤAMPµÄÓû§À´Ëµ£¬ºÃ´¦¶à¶à¡£
Ò»¡¢Ê¹ÓÃAMP¼¯³ÉÈí¼þµÄÓŵ㣺
1¡¢¿É±ÜÃâÓÉÓÚȱ·¦AMPµÄ֪ʶ£¬¶øÎÞ·¨ÕýÈ·ÉèÖû·¾³£»
2¡¢¿É¿ìËÙ°²×°²¢ÉèÖúÃAMP»·¾³£¬ÈÃÎÒÃÇÖ±½Ó¿ªÊ¼ÕæÕý¸ÐÐËȤµÄÈí¼þ£¬Èçxoops£»
3¡¢¿É·½±ãµÄ´î½¨²âÊÔ»·¾³£¬¶ÔÓÚ² ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ