I have a problem regarding unicode characters and MySql.
I am using MySql 4.1 and MySql Connector/NET together with
C#.

My question is whether I' am making a silly mistake (or not),
by not being able to store unicode characters in a simple table.

The database I have created is supposed to be in unicode:
'CREATE DATABASE test CHARACTER SET utf8'.

Now, connecting from C#, i am trying to write into a simple
table, with one column, the value '\u0120\u0121\u0125\u0411'
but when I am retrieving the value from the table, '????' is
returned as a result.

I don't know if its relevant, but i have checked that the
server and connection are using unicode encoding:

SHOW VARIABLES LIKE 'character_set_server' which returns
'utf8' as a result.

also:
SHOW VARIABLES LIKE 'character_set_connection' returns
'utf8' as a result.

I would very much appreciate if someone would answer this
question.

Thanks in advance, and looking foward to hearing from someone,
Duncan.