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

Mysql ʹÓÃÎÊÌâ - Java / Web ¿ª·¢

ÎÒµÄMysql ʹÓõÄʱºò ÓÃdos½¨Á¢µÄÊý¾Ý±í ÔÚdosÖÐÄÜÏÔʾ³öÖÐÎÄ 
µ«ÊÇÔÚ ÆäËûµÄ¿ÉÊÓÒ³Ãæ ºÍÍøÒ³Öж¼ÏÔʾÂÒÂë ÈçºÎ½â¾ö£¿
ÔÚmysql¿ØÖÆÌ¨:show variables like 'char%';Ìù½á¹û³öÀ´¿´¿´¡£

mysqlÃüÁîÐÐģʽÏÂ:SHOW VARIABLES LIKE '%charac%'
¿´¿´ÄãµÄÊý¾Ý¿â±àÂë

Òª¸Ä±äÆäÖÐÒ»¸ö, ¾ÍʹÓÃ
set character_set_client = UTF8;

ÆäÖÐ
character_set_client | utf8 ¿Í»§¶Ë, Ò²¾ÍÄ㵱ǰÃüÁîÐÐϵıàÂë, Ò²¿ÉÒÔʹÓÃset names gbkÕâÑùÉèÖÃ
character_set_connection | utf8 Á¬½Ó±àÂë
character_set_database | utf8 Êý¾Ý¿â±àÂë
character_set_filesystem | binary Êý¾Ý¿âµ×²ãÎļþϵͳ±àÂë
character_set_results | utf8  
character_set_server | utf8
character_set_system | utf8

È«²¿×ªÎªutf-8ÊÔÊÔ°É.

±àÂëÎÊÌ⣬ËùÓеĵط½ÒªÊ¹ÓÃÏàͬµÄ±àÂ룻CMDºÚ´°¿ÚÀïÊÇÓõÄGBK±àÂ룬Äã³ÌÐòÀïÆäËûµÄµØ·½ÄØ£¿

×Ö·û¼¯µÄÎÊÌâ

°²×°µÄʱºò£¬ÈÃÄãÑ¡±àÂëµÄ£¬¿ÉÄÜÄãûÓÐ×¢Ò⣡

ÎÒÓõıàÂëÊÇgb2313£¡£¡ È»ºóÔÚMysql µÄ¿ÉÊÓ½çÃæÖиü¸ÄÊý¾Ýʱ Ëü²»Èøü¸Ä 1406 - data too long for column £¡£¡

ÎÒÓõıàÂëÊÇgb2312£¡£¡ È»ºóÔÚMysql µÄ¿ÉÊÓ½çÃæÖиü¸ÄÊý¾Ýʱ Ëü²»Èøü¸Ä 1406 - data too long for column £¡£¡

Èç¹û¿ØÖÆÌ¨´òÓ¡µÄÊÇÖÐÎÄ£¬ÄÇôӦ¸Ã²»ÄÜ»³ÒÉmysqlµÄ±àÂë¡£

½¨ÒéÔÚResultSetÈ¡Êý¾ÝʱÈÕÖ¾´òӡһϣ¬¿´ÊÇ·ñ´ÓÊý¾Ý¿â¸Õ¶Á³öʱ¾ÍÊÇÂÒÂë¡£

Èç¹ûÊÇ£¬ÄÇô¿ÉÒÔÐÞ¸ÄmysqlĿ¼ÖеÄmy.iniÎļþ£¬ÀïÃæÓÐÁ½¸ö½Úµã¿ÉÒÔ¸ü¸Ä±àÂ뷽ʽ



ÒýÓÃ
ÎÒÓõıàÂëÊÇgb2312£¡£¡ È»ºóÔÚMysql


Ïà¹ØÎÊ´ð£º

Java RandomAccessFile дÈëtxtÎļþ - Java / Java SE

ÓÃRandomAccessFileдÈëTXTÎļþ²é¿´Ê±ÊÇÂÒÂ룬ÇëÎÊÓÐʲô·½·¨¿ÉÒÔд³É¿É¶ÁµÄÎļþ£¬²»ÊÇÓÃÆäËûµÄÎļþ²Ù×÷£¬¾ÍÊÇÖ»ÓÃRandomAccessFileµÄ·½·¨ÊÇ·ñ¿ÉÒÔʵÏÖ£¿
Java code:
import java.io.*;
public class RandomAcce ......

mysqlµÄÁ¬½Ó³¬Ê±Ê±¼äÔõôÉèÖà - VC/MFC / Êý¾Ý¿â

ÎÒÊÇÓÃmysql×Ô´øµÄC API
if(mysql_real_connect(&mysql,"125.0.0.108","root","root","home",3306,NULL,0))

AfxMessageBox("Êý¾Ý¿âÁ¬½Óʧ°Ü") ......

java³ÌÐòÁ¬½ÓSQlServerµÄÎÊÌâ - Java / Java SE

import java.sql.Connection;
import java.sql.Date;
import java.sql.DriverManager;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.sql.Statement;
public class QueryTest&n ......

ÈçºÎ¶¨ÆÚɾ³ýmysqlÊý¾Ý - PHP / »ù´¡±à³Ì

ÇëÎÊÏÂÄܲ»ÄÜÔÙwindows϶¨ÆÚÇå¿ÕmysqlÒ»¸ö±íÖеÄÈ«²¿Êý¾Ý£¬ÓÃPHPʵÏÖ£¡
лл¸÷λÁË
¾Í±ÈÈçÒ»¸öÐÇÆÚÇå¿ÕÒ»´Î
±ÈÈçÿ¸öÐÇÆÚÁùÁãµãÇå¿ÕÒ»´Î£¡
ллÁË

¼Æ»®ÈÎÎñ...php....sql...truncate....OK

Äã¾ÍÕâ½ÓÔÚҳà ......

java ÐÂÊÖÇó½è

eclipse ´´½¨ webservice
jquery ÈçºÎµ÷Óà java ´´½¨µÄ webservice

ûÓö¼û¹ý,ÆÚ´ý¸ßÊÖ½â´ð!
up


¿´¿´£¬(¡Ño¡Ñ)

Ö÷Òª¸æËßÎÒ jquery ÈçºÎµ÷Óà java ´´½¨µÄ webservice


ºÜ"³éÏó"µÄÎÊÌâ
LZ ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ