MySQL数据库不同插入

Question

From my server, I create and execute a query to my database. The query looks like this:

INSERT INTO `table`(`attr`) 
VALUES (
  'myText',
  ...
);

Insert works fine, but when the myText is (for example) the € character, it inserts € (ISO representation). When I execute a query inside phpMyAdmin with this character, it works. Could somebody tell me where is the problem?

NOTE: in PHP, myText, which is inserted into a query, is € - so it´s not converted to ISO representation before the query.

UPDATE: I use MySQL 5.5

UPDATE 2: I have CHARSET=utf8 COLLATE=utf8_bin on my table.

Answer 1

Immediately after mysql connection, before any query, use this:

mysql_connect(...);
mysql_select_db(...);
mysql_query("SET NAMES 'utf8'");

from then on, you can use queries and utf8 chars will be displayed properly.

UPDATE:

Don't forget to put <meta http-equiv="Content-Type" content="text/html; charset=utf-8"> in your document.