Bug #8235 Connection collation change & table create with default result in crash

Description:
In stock mysql 4.1.9, the following 2 queries executed on one connection result in a "#2013 - Lost connection to MySQL server during query" error. 

SET collation_connection='ucs2_swedish_ci';
CREATE TABLE TestTable( Field1 int( 10 ) default '0' );

If the table type is MyISAM, the table is created normally, and can be dropped.
If the table type is InnoDB, the table cannot be dropped and shows as 'in use'.

When you use a default value without the quotes, no error occurs.
eg: CREATE TABLE TestTable( Field1 int( 10 ) default 0 );

Error occurs when you set the connection collation to anything other then the current server collation.

How to repeat:
SET collation_connection='ucs2_swedish_ci';
CREATE TABLE TestTable( Field1 int( 10 ) default '0' );

On stock 4.1.9

Suggested fix:
More collation checks?

Thank you for the bug report. I was able to repeat on current
BK source tree.

Also 5.0 tree is affected.

Fixed in 4.1.10.

I haven't merged into 5.0.x though, because of conflicts
in someone's else changes.

Noted in 4.1.10, 5.0.3 changelogs.