[Phpmyadmin-devel] [Drizzle] Charset and Collation issue
azhari at harahap.us
Fri Apr 8 14:53:27 CEST 2011
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
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
I already send patch for this issue 
But, i got another issue, for example when submit Create table form,
it thrown error "CHARACTER SET" because it's removed on Drizzle ,
but "COLLATE" seems to be supported 
I'll give more investigation on this issue.
-------------- next part --------------
An HTML attachment was scrubbed...
More information about the Developers