mysqlÂÒÂëÎÊÌâ
½â¾öMySqlÊý¾ÝÂÒÂë:
1 д¹ýÂËÆ÷ÉèÖñàÂë¸ñʽ(¸ñʽºÍJSPÒ³ÃæµÄ±àÂëÒ»Ñù)£¬»òÔòÔÚÇëÇóÀïÃæдrequest.setCharacterEncoding("±àÂ뷽ʽ");
2 Èç¹ûÊDzéѯ³öÊý¾ÝÂÒÂ룬ÔÚÁ´½ÓµÄURLÉϼÓÉϱàÂë¸ñʽ(ÄãÕâÀï¼ÓÁË£¬Ã»ÎÊÌâ);
3 ÐÞ¸Ämy.iniÎļþÀïÃæµÄ default-character-set= ÄúÒªµÄ±àÂë¸ñʽ (Ò»¹²ÓÐÁ½´¦£¬Äã²éÕÒһϠ¸ÄΪһÑùµÄ±àÂë¸ñʽ)
3 Èç¹ûÊÇдÈëµ½Êý¾Ý¿âÖ®ºóÊÇÂÒÂë(Ç°ÌáÊÇÒѾдÁ˹ýÂËÆ÷´¦Àí±àÂë),ÐÞ¸Ämy.iniÎļþÀïÃæ²éÕÒsql-mode ÉèÖà sql-mode =
"NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION";
ÊÔÊÔ°É£¡
ÕâÊÇËùÓÐÂÒÂëµÄÇé¿ö£¡ ÎÒÓõÄÊÇMYSQL5.0 ½â¾öÂÒÂë¾ÍÕâÑù¸ãµÄ£¡£¡£¡£¡£¡£¡£¡
Êý¾Ý¿â±àÂë²ÉÓÃUTF8£¬Í¬Ñù£¬ÐÞ¸ÄÁ¬½Ó×Ö·û´®Îª£ºjdbc:mysql://localhost:3306/BookDB?useUnicode=true&characterEncoding=utf8
½«ÄãµÄdefault-character-set=latin1 ¸Ä³Édefault-character-set=gbkÊÔÊÔ.
ÔÚ°²×°µÄʱºòÑ¡ÔñGBK¾Í¿ÉÒÔ.»òÕßÔÚMY.INIÀïÃæ¸ÄÒ²¿ÉÒÔ.
д¹ýÂËÆ÷ÉèÖñàÂë¸ñʽ¡£
»òÕßÊÇ°Ñ´ÓÊý¾Ý¿âÖжÁ³öµÄ×Ö·ûÏÈת³ÉbyteÊý×飬ÔÚ±àÂë³Éutf-8,±£Ö¤½â¾öÎÊÌâ
½â¾ö·½·¨:
ËùÓеıàÂ붼ʹÓÃÒ»ÖÖÈç:utf8
1.Êý¾Ý¿â±àÂë:
String dbUrl = "jdbc:mysql://localhost:3306/BookDB&useUnicode=true&characterEncoding=utf8";
2.jsp±àÂë
<%@ page language="java" contentType="text/html; charset=utf8"%>
3.Ôö¼Ó¼Ç¼µÄ¶¼×ª»»Îªutf8±àÂëÈçÏÂ:
content = new String(content.getBytes("iso8859-1"),"utf8"));
Ðí¶à×Ö·û´®Êý¾ÝÀàÐ͵ÄÁж¨Òå¿ÉÒÔ°üÀ¨Ö¸¶¨×Ö·û¼¯µÄCHARACTER SETÊôÐÔ£¬Ò²¿ÉÄÜ°üÀ¨Ð£¶Ô¹æÔò¡£(CHARSETÊÇCHARACTER SETµÄÒ»¸öͬÒå´Ê£©¡£ÕâЩÊôÐÔÊÊÓÃÓÚCHAR¡¢VARCHAR¡¢TEXTÀàÐÍ¡¢ENUMºÍSET¡£ÀýÈ磺
· CREATE TABLE t
· (
· c1 CHAR(20) CHARACTER SET utf8,
· c2 CHAR(20) CHARACTER SET latin1 COLLATE l
Ïà¹ØÎĵµ£º
MySQL ÂÒÂëµÄ¸ùÔ´ÊÇµÄ MySQL ×Ö·û¼¯ÉèÖò»µ±µÄÎÊÌ⣬±¾ÎÄ»ã×ÜÁËÓйز鿴 MySQL ×Ö·û¼¯µÄÃüÁî¡£°üÀ¨²é¿´ MySQL Êý¾Ý¿â·þÎñÆ÷×Ö·û¼¯¡¢²é¿´ MySQL Êý¾Ý¿â×Ö·û¼¯£¬ÒÔ¼°Êý¾Ý±íºÍ×ֶεÄ×Ö·û¼¯¡¢µ±Ç°°²×°µÄ MySQL ËùÖ§³ÖµÄ×Ö·û¼¯µÈ¡£
Ò»¡¢²é¿´ MySQL Êý¾Ý¿â·þÎñÆ÷ºÍÊý¾Ý¿â×Ö·û¼¯¡£
mysql> show variables like '%char%';
+-- ......
Mysql my.ini ÅäÖÃÎļþÏê½â
#BEGIN CONFIG INFO
#DESCR: 4GB RAM, ֻʹÓÃInnoDB, ACID, ÉÙÁ¿µÄÁ¬½Ó, ¶ÓÁиºÔØ´ó
#TYPE: SYSTEM
#END CONFIG INFO
#
# ´ËmysqlÅäÖÃÎļþÀý×ÓÕë¶Ô4GÄÚ´æ
# Ö÷ҪʹÓÃINNODB
#´¦Àí¸´ÔÓ¶ÓÁв¢ÇÒÁ¬½ÓÊýÁ¿½ÏÉÙµÄmysql·þÎñÆ÷
#
# ½«´ËÎļþ¸´ÖƵ½/etc/my.cnf ×÷Ϊȫ¾ÖÉèÖÃ,
# mysql-data-d ......
Jsp Á¬½Ó mySQL¡¢Oracle Êý¾Ý¿â±¸Íü
2009-12-15 16:47
Jsp »·¾³Ä¿Ç°×îÁ÷ÐеÄÊÇ Tomcat5.0¡£Tomcat5.0 ×Ô¼º°üº¬Ò»¸ö Web ·þÎñÆ÷£¬Èç¹ûÊDzâÊÔ£¬¾Íû±ØÒª°Ñ Tomcat Óë IIS »ò Apache ¼¯³ÉÆðÀ´¡£ÔÚ Tomcat ×Ô´øµÄ Web ·þÎñÆ÷Ï¿ÉÒÔ½øÐÐ Jsp ²âÊÔ¡£
°²×° Tomcat5.0 Ç°ÐèÒª°²×° JDK(Èç¹ûÊÇ Windows server ......
update article set body = (REPLACE(body, '</div>', ' ')) where typeid=21
ÓÃupdateºÍreplaceÔÚmysqlÖÐÌ滻ijһ¸ö×ֶεIJ¿·ÖÄÚÈÝ
update users_settings set `ConfigValue` = replace(configvalue,' fromstr' 'tostr') where `ConfigName`='accesslist'
¶ÔÓÚÕë¶Ô×Ö·û´®Î»ÖõIJÙ×÷£¬µÚÒ»¸öλÖñ»±ê¼Ç ......
130 £ºÎļþ¸ñʽ²»ÕýÈ·¡££¨»¹²»ÊǺÜÇå³þ´íÎóµÄ×´¿ö£©
145 £ºÎļþÎÞ·¨´ò¿ª¡£
1005£º´´½¨±íʧ°Ü¡£
1006£º´´½¨Êý¾Ý¿âʧ°Ü¡£
1007£ºÊý¾Ý¿âÒÑ´æÔÚ£¬´´½¨Êý¾Ý¿âʧ°Ü¡£
1008£ºÊý¾Ý¿â²»´æÔÚ£¬É¾³ýÊý¾Ý¿âʧ°Ü¡£
1009£º²»ÄÜɾ³ýÊý¾Ý¿âÎļþµ¼ÖÂɾ³ýÊý¾Ý¿âʧ°Ü¡£
1010£º²»ÄÜɾ³ýÊý¾ÝĿ¼µ¼ÖÂɾ³ýÊý¾Ý¿âʧ°Ü¡£
1011£ºÉ ......