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=23... [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