Bug #4383 Default database charset is ignored when table is created
Submitted: 2 Jul 2004 15:58 Modified: 2 Jul 2004 16:58
Reporter: Michael G. Zinner Email Updates:
Status: Duplicate Impact on me:
None 
Category:MySQL Server Severity:S3 (Non-critical)
Version:4.1.2 alpha OS:Windows (Win 2k)
Assigned to: Assigned Account CPU Architecture:Any

[2 Jul 2004 15:58] Michael G. Zinner
Description:
When a table is created by

create table big5.big5_c(id integer, name varchar(45));

the table doesn't use the default charset defined with CREATE DATABASE big5 CHARACTER SET big5;

It works when there has been a USE big5 statement before.

How to repeat:
Don't use the USE command and create a table.
[2 Jul 2004 16:58] Guilhem Bichot
A duplicate of BUG#2326 if I am not mistaken. Bar has sent a patch for review so this will be fixed soon.