[Phpmyadmin-devel] [Drizzle] Charset and Collation issue

[Azhari Harahap]

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
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.phpmyadmin.net/pipermail/developers/attachments/20110408/ceaa5f02/attachment.html>