已经正常连接了,唯一的不足就是,无法往数据库输入中文会产生:[MySQL][ODBC 3.51 Driver][mysqld-5.0.18-nt]Data too long for column 'SmallClassName' at row 1
的错误由于ASP连MYSQL是第一次,没有经验,以上错误,弄了好久一直找不到解决的办法mysql-5.0.18-win32, iis5.0 , mysql-odbc 3.51 , win2000sp4 数据库无论是通过MYSQL-FRONT直接从ACCESS数据库导入,还是手动建库建表都存在同样的问题my.ini中两处,c/s端都设为了default-character-set=gb2312建库建表时也设为了gb2312还是存在同样的问题希望有高手指教
的错误由于ASP连MYSQL是第一次,没有经验,以上错误,弄了好久一直找不到解决的办法mysql-5.0.18-win32, iis5.0 , mysql-odbc 3.51 , win2000sp4 数据库无论是通过MYSQL-FRONT直接从ACCESS数据库导入,还是手动建库建表都存在同样的问题my.ini中两处,c/s端都设为了default-character-set=gb2312建库建表时也设为了gb2312还是存在同样的问题希望有高手指教
mysql> show variables like "%char%";
+--------------------------+----------------------------------------------------
-----+
| Variable_name | Value
|
+--------------------------+----------------------------------------------------
-----+
| character_set_client | gb2312
|
| character_set_connection | gb2312
|
| character_set_database | gb2312
|
| character_set_filesystem | binary
|
| character_set_results | gb2312
|
| character_set_server | gb2312
|
| character_set_system | utf8
|
| character_sets_dir | C:\Program Files\MySQL\MySQL Server 5.0\share\chars
ets\ |
+--------------------------+----------------------------------------------------
-----+
8 rows in set (0.16 sec)mysql> show tables;
+----------------+
| Tables_in_test |
+----------------+
| aa |
+----------------+
1 row in set (0.06 sec)mysql> select * from aa;
+----+----------+
| id | name |
+----+----------+
| 1 | 社会时事 |
| 2 | 国际时事 |
+----+----------+
2 rows in set (0.06 sec)mysql> insert into aa values(3,'时事政治');
Query OK, 1 row affected (0.06 sec)mysql> select * from aa;
+----+----------+
| id | name |
+----+----------+
| 1 | 社会时事 |
| 2 | 国际时事 |
| 3 | 时事政治 |
+----+----------+
3 rows in set (0.00 sec)
+--------------------------+--------------------------+
| Variable_name | Value |
+--------------------------+--------------------------+
| character_set_client | gb2312 |
| character_set_connection | gb2312 |
| character_set_database | gb2312 |
| character_set_results | gb2312 |
| character_set_server | gb2312 |
| character_set_system | utf8 |
| character_sets_dir | D:\MySQL\share\charsets\ |
+--------------------------+--------------------------+
7 rows in set (0.09 sec)
可以告诉我是怎么样 连接的mysql数据库吗?
我连接不上 谢谢
加上这一句就可以解决了.我这里顺利解决.