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

dominoÁ¬½Ómysql²åÈëÖÐÎÄÄÚÈݳöÏÖÂÒÂëµÄ½â¾ö·½°¸

    ½üÈÕ£¬ÓÐÒ»¸öÏîÄ¿ÐèҪͨ¹ýOAϵͳ£¨Dominoƽ̨£©ÏòÒ»¸öMySQLÓ¦ÓòåÈë¼Ç¼£¬ÒòΪƽ̨ÊÇwindowsƽ̨£¬ËùÒÔ²ÉÓÃÁËODBCÁ¬½Ó·½Ê½£¬ÔÚOA·þÎñÆ÷Éϰ²×°ÁËMyODBC-3.51.11-1Çý¶¯£¬ÅäÖÃÁËODBCÇý¶¯Êý¾ÝÔ´Ö®ºó£¬²åÈë¼Ç¼³É¹¦£¬µ«²»ÂÛÊDzåÈëÖÐÎÄÄÚÈÝ£¬»¹ÊÇ´ÓMySQLÖжÁÈ¡ÖÐÎÄÄÚÈÝ£¬¶¼ÊÇÂÒÂ룬ÔÚÍøÉϲéÔÄÁ˸÷ÖÖ×ÊÁÏ£¬³õ²½ÅжϿÉÄÜÊÇ×Ö·û¼¯µÄÔ­Òò£¬Domino²ÉÓõÄÊÇgb2312£¬MySQL²ÉÓõÄÊÇgbk£¬Á½ÖÖ²»Í¬×Ö·û¼¯µ¼ÖÂÖÐÎÄÂÒÂëÎÊÌ⣬ÏÖÔÚÀ´¸ü¸ÄÁ½ÖÖÊý¾Ý¿âµÄ×Ö·û¼¯ÊDz»ÏÖʵµÄ£¬Ö»ºÃÔÚÆäËû·½ÃæÕÒ½â¾ö°ì·¨¡£
    DominoµÄODBCÁ¬½Ó·½Ê½ÔÚconnecttoµÄʱºòÊDz»ÄÜÖ¸¶¨×Ö·û¼¯µÄ¡£ÔÚÍøÉÏËÑË÷×ÊÁÏÖ®ºó£¬·¢ÏÖ¿ÉÒÔÔÚMYODBCÇý¶¯ÉÏÅäÖòÎÊý£¬´ïµ½¸øMySQLÊý¾Ý¿âÖ¸¶¨×Ö·û¼¯µÄ¹¦ÄÜ¡£ÅäÖÃÈçÏ£º 
 
ÕâÀï×¢Ò⣬һ¶¨ÒªÔړϵͳDSN”ÖÐÅäÖ㬿ªÊ¼ÎÒÔÚ“Óû§DSN”ÖÐÅäÖÃÎÞЧ¡£ 
 
ÔÚ“Connect Options”Ñ¡ÏÖеēInitial Statement”ÖÐÊäÈëÈçÏÂÓï¾ä£ºset names gb2312
ÕâÌõÓï¾ä¾ÍÊÇÇ¿ÖÆ½«MySQLµÄ×Ö·û¼¯Éè³Égb2312¡£
ÖÁ´Ë£¬ÂÒÂëÎÊÌâ½â¾ö¡£OK£¡£¡£¡


Ïà¹ØÎĵµ£º

mySQLµÄÖÐÎÄ×Ö·û´¦Àí

1.Ê×ÏÈ£¬ÉèÖÃÊý¾Ý¿âÖ§³ÖÖÐÎÄgb2312/gbk¡£
¾ßÌå·½·¨£º
´ò¿ªmySQLÎļþ¼Ð£¬ÐÞ¸Ämy.iniÅäÖÃÎļþ¡£
[client]
port=3306
default-character-set=gb2312
ÒÔ¼°
[mysqld]쵀
default-character-set=gb2312
Ð޸쬱£´æ£¬ÖØÆô¡£ÈôÉèΪSystem·þÎñ£¬¿ÉÒÔÔÚ¿ØÖÆÃæ°å-¹ÜÀí¹¤¾ß-·þÎñÖÐÕÒµ½mySQL·þÎñ£¬ÖØÆô¡£
2.±£Ö¤Web ......

Ò»ÖÖ²»´íµÄ´ÓSQLתMysqlÊý¾Ý¿âµÄ·½·¨

Äê³õµÄʱºòÒ»Ö±ÔÚ×öÒ»¸öÍøÕ¾MSSQL2000->MySQL5µÄÇ¨ÒÆ¹¤×÷£¬ÒòΪ²ÉÓÃÁ˲»Í¬µÄ³ÌÐòϵͳ£¬ËùÒÔÖ÷ÒªÎÊÌâÔÚÊý¾ÝµÄÇ¨ÒÆ¡£ÓÉÓÚ2¸öϵͳÊý¾Ý¿â½á¹¹²îÒì·Ç³£´ó£¬²»·½±ã²ÉÈ¡SQLSERVERÀïµ¼ÈëMYSQLµÄODBCÊý¾ÝÔ´µÄ¹¦ÄÜ£¨Ò²²»ÍƼöÕâô×ö£¬×Ö¶ÎÀàÐ͵Ȳ»Í¬µã»á¸ãËÀÈ˵ġ«£©£¬Òò´Ë¾ÍÔÚWINDOWSÏÂ×Ô¼ºÐ´PHP½Å±¾´ÓSQLSERVERÀï¶ÁÊý¾Ý£¬È»ºó°´ÕÕ ......

jBPM4ÖÐÅäÖÃMySQLµÄhibernate·½ÑÔ

×î³õµÄjbpm.hibernate.cfg.xmlÖУ¬¶ÔMySQLµÄ·½ÑÔÅäÖóÉÁËorg.hibernate.dialect.MySQLDialect£¬·¢²¼Á÷³ÌµÄʱºòÓöµ½ÏÂÊö´íÎó£º
Cannot delete or update a parent row: a foreign key constraint fails
Could not synchronize database state with session
½«MySQL·½ÑÔÐÞ¸ÄΪorg.hibernate.dialect.MySQLInnoDBDialectÎÊ ......

mysql´æ´¢ÒýÇæµÄË÷Òý¶Ô±È

´æ´¢ÒýÇæ Ö§³ÖË÷Òý myisam b-tree,r-tree,full-text,²»Ö§³Öhash innodb b-tree(clustered-index) merge b-tree,r-tree memory b-tree,hash archive ÎÞË÷Òý ......

MySQL ÄÚ´æÄ£ÐÍ hust ei

¶ÔÓÚÈκÎÒ»¸öÊý¾Ý¿â¹ÜÀíϵͳÀ´Ëµ£¬ÄÚ´æµÄ·ÖÅäʹÓþø¶Ô¿ÉÒÔËãµÄÉÏÊÇÆäºËÐÄÖ®Ò»ÁË£¬ËùÒԺܶàÏ£Íû¸üΪÉîÈëÁ˽âijÊý¾Ý¿â¹ÜÀíϵͳµÄÈË£¬¶¼»áÏ£ÍûÒ»¿ú¾¿¾¹£¬ÎÒÒ²²»ÀýÍâ¡£
´ÓÄÚ´æµÄʹÓ÷½Ê½MySQL Êý¾Ý¿âµÄÄÚ´æÊ¹ÓÃÖ÷Òª·ÖΪÒÔÏÂÁ½Àà
* Ï̶߳ÀÏíÄÚ´æ
* È«¾Ö¹²ÏíÄÚ´æ
½ñÌìÕâÆªÎÄÕÂÔÝʱÏÈ·ÖÎö MySQL ÖÐÖ÷ÒªµÄ “Ï̶߳ÀÏíÄ ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ