Bug #42530 ALTER TABLE fails when charset is changed from hebrew to utf8 with ibmdb2i
Submitted: 2 Feb 2009 5:38 Modified: 21 Apr 2009 6:34
Reporter: Nirbhay Choubey Email Updates:
Status: Closed Impact on me:
None 
Category:MySQL Server: DB2SE for IBM i Severity:S3 (Non-critical)
Version:5.1.30 OS:Other (IBMi 5.4)
Assigned to: Nirbhay Choubey CPU Architecture:Any

[2 Feb 2009 5:38] Nirbhay Choubey 
Description:
ALTER TABLE t1 CONVERT TO CHARACTER SET utf8; 

The above statement fails when executed with 'ibmdb2i' storage engine, with the following error :

ERROR 1296 (HY000): Got error 2512 'Error in iconv() function during character set conversion (errno = 22)' from IBMDB2I

Note: hebrew & utf8 is supported in IBMi 5.4

How to repeat:
DROP TABLE IF EXISTS t1;
SET NAMES hebrew;
CREATE TABLE t1 (a char(1)) DEFAULT CHARSET=hebrew;
INSERT INTO t1 VALUES (0xFD),(0xFE);
ALTER TABLE t1 CONVERT TO CHARACTER SET utf8;
[21 Apr 2009 6:34] Nirbhay Choubey 
Fixed by IBM.
Verified from the mysql-5.1.33/ibmdb2i release.