| Bug #5420 | Access violation at address 0072CC16 in module 'iconv.dll'. | ||
|---|---|---|---|
| Submitted: | 5 Sep 2004 16:18 | Modified: | 1 Dec 2004 13:45 |
| Reporter: | Panco Cheong | Email Updates: | |
| Status: | No Feedback | Impact on me: | |
| Category: | MySQL Query Browser | Severity: | S1 (Critical) |
| Version: | 1.0.7 beta | OS: | Windows (Windows XP SP1 Trad. Chinese) |
| Assigned to: | Assigned Account | CPU Architecture: | Any |
[6 Sep 2004 11:02]
Michael G. Zinner
Thanks for reporting. I tried to reproduce your problem but did not suceed. Could you state which server version you are using? Could you also try to alter the default database to UTF8 (if it's not already in UTF8): ALTER DATABASE xxx CHARACTER SET utf8 COLLATE utf8_bin; test> show create database test; +------------------+---------------------------------------------------------------------------------+ | Database | Create Database | +------------------+---------------------------------------------------------------------------------+ | test | CREATE DATABASE `test` /*!40100 DEFAULT CHARACTER SET utf8 COLLATE utf8_bin */ | +------------------+---------------------------------------------------------------------------------+ Query executed in 0.0004s, retrieved in 0.0000s. test> Could you try to execute the update statements in the GUI console (View > GUI Command Line)? Can you edit other fields except the DECIMAL(4, 0) ? Thanks a lot!
Description: C:\windows\my.ini ------------------------------------------------------------------------ [mysqld] default-character-set=utf8 default-collation=utf8_bin ------------------------------------------------------------------------ mysql client (there is no problem with the mysql client) ------------------------------------------------------------------------ mysql> CREATE TABLE `t1` ( -> `c1` mediumint(8) unsigned NOT NULL default '0', -> `c2` varchar(45) character set utf8 default NULL, -> `c3` DECIMAL(4,0), -> PRIMARY KEY (`c1`) -> ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin; Query OK, 0 rows affected (0.00 sec) mysql> insert into t1 values (1,"my comment",2004); Query OK, 1 row affected (0.00 sec) ------------------------------------------------------------------------ mysql query browser ------------------------------------------------------------------------ when edit the field with type = decimal(4,0) (eg. change 2004 to 2002), the mysql query browser prompt this error message. Access violation at address 0072CC16 in module 'iconv.dll'. Read of address FFFFFFFF How to repeat: mysql query browser ------------------------------------------------------------------------ when edit the field with type = decimal(4,0) (eg. change 2004 to 2000), the mysql query browser prompt this error message. Access violation at address 0072CC16 in module 'iconv.dll'. Read of address FFFFFFFF