MySql

Unicode in MySql

there is a very important point which is normaly unseen during the use of mysql in a unicode environment. and that is not only the encoding of database, table, column should be set to unicode but also the connection's characterset should be set to unicode. otherwise it would result in some strange functionalities later. it can and most be done using the command:

SET NAMES utf8

not setting it would result in double encoding the chars and having porblem with all string functions inside mysql.