Hi all

I've been started to look at Drizzle compability with MySQL, and the first issue i got is the Charset and Collation

I've been looking through Drizzle documentation and it said that currently Drizzle only support utf8 charset and collation. But as i seen the code on latest trunk, phpMyAdmin simply disable it rather than set it to utf8.

As i tested on Drizzle7 2011.03.13, we can look at supported charset by query:

SELECT * from DATA_DICTIONARY.CHARACTER_SETS; As replacement of SHOW CHARACTER SET; on MySQL

And for the collation:

SELECT * from DATA_DICTIONARY.COLLATIONS; As replacement of SHOW COLLATION; on MySQL

But, the table structure is little bit confusing here, because in MySQL we can match the `Charset` field on both result, but in Drizzle i've to match `CHARACTER_SET_NAME` on charset result and `DESCRIPTION` on collation result.

At least, now phpMyAdmin can show correct charset and collation on the Charsets menu.

I already send patch for this issue [1]

But, i got another issue, for example when submit Create table form, it thrown error "CHARACTER SET" because it's removed on Drizzle [1], but "COLLATE" seems to be supported [2]

I'll give more investigation on this issue.

[1] https://sourceforge.net/tracker/?func=detail&aid=3280876&group_id=23067&atid=377410

[2] http://docs.drizzle.org/mysql_differences.html#objects-removed

[3] http://docs.drizzle.org/create_table.html?highlight=create%20table#data-type

Regards

Azhari Harahap

http://azhari.harahap.us