I was trying to connect phpmyadmin with drizzle. It says error in SQL Query : SET CHARACTER SET 'utf8'... I tried running it in drizzle and same error appears there. How can i disable the charsets/collations that we do on connect ?
And is there any specific reason for why drizzle does not support utf8 while mysql does ?
___ Regards Aamir Khan
2011/2/21 AAMIR KHAN ak4u2009@gmail.com:
I was trying to connect phpmyadmin with drizzle. It says error in SQL Query : SET CHARACTER SET 'utf8'... I tried running it in drizzle and same error appears there. How can i disable the charsets/collations that we do on connect ?
Use phpMyAdmin from master branch or newest 3.4 beta, it can connect to Drizzle though MySQL protocol.
And is there any specific reason for why drizzle does not support utf8 while mysql does ?
Drizzle is made to be a simpler and more scalable DBMS than MySQL, and it supports only UTF-8 - all other character sets are gone, along with SQL queries that allow for their use. You may want to look into official docs [1] to look for differences. I already researched it a little as I want to implement full Drizzle support during this year's GSoC :)
[1] http://docs.drizzle.org/mysql_differences.html
Hi
Dne Mon, 21 Feb 2011 05:16:55 +0530 AAMIR KHAN ak4u2009@gmail.com napsal(a):
I was trying to connect phpmyadmin with drizzle. It says error in SQL Query : SET CHARACTER SET 'utf8'... I tried running it in drizzle and same error appears there. How can i disable the charsets/collations that we do on connect ?
The only phpMyAdmin version which can connect to Drizzle is 3.4. And by saying can connect I mean that's all what was tested and there are lot of other things which are broken. See my mail on this list from last October for more details: http://thread.gmane.org/gmane.comp.php.phpmyadmin.devel/7602
And is there any specific reason for why drizzle does not support utf8 while mysql does ?
Drizzle does not support many of MySQL features. It was made to be much simpler.
-
AAMIR KHAN -
Michal Čihař -
Piotr Przybylski