Categories
MySQL

MySQL Workbench 6.x Preview

MySQL Workbench, a visual editor for MySQL database, one of the free and popular tool to manage database and modeling. MySQL Workbench version 6.x has been release since July 2013 after a long running of version 5.x. Here are some screenshot of MySQL Workbench 6.0.8 that I just installed: Learn more.

Categories
PostgreSQL

A recommandation or a Free GUI Tool for ER Diagram for PostgreSQL

pgAdmin3 which is coming by default when we install PostgreSQL but there is no GUI data modeling. Found from following list, there are some GUI tool but don’t know which one should be taking into account. – http://wiki.postgresql.org/wiki/GUI_Database_Design_Tools – http://wiki.postgresql.org/wiki/Community_Guide_to_PostgreSQL_GUI_Tools Is there any recommended tool for GUI database modeling with ER Diagram like we have…

Categories
MySQL

MySQL issue & Solution: Illegal mix of collations for operation ‘=’

MySQL Error Illegal mix of collations (utf8_general_ci,IMPLICIT) and (utf8_unicode_ci,IMPLICIT) for operation '=' Overview I have two databases in mysql, I have written a sql to compare two table (dbA.contact & dbB.actor). Example: SELECT dbB.* FROM dbA.contact co, dbB.actor ac WHERE co.name = ac.name When I execute the request, I will get above error, why it…