Adding symbol ≥ in mysql table fails.

[nando76]

Hi,
i use mysql and try to save the bigger-equal sign '≥' into a db attribute.

I use something like
@query.prepare("INSERT INTO test (ID, operator) VALUES (0, :operator)";
query.bindValue(":operator", "≥");
query.exec()@

i always get:
Incorrect string value: '\xE2\x89\xA5' for column 'operator' at row 1 QMYSQL3: Unable to execute statement

columns in db should be utf8 encoded...

Any Ideas?

Greetings
Nando

[SGaist]

Hi,

Are you sure everything is setup correctly ?

"This":http://jamesreubenknowles.com/setting-mysql-to-default-to-unicode-1861 might be of interest

Hope it helps

[nando76]

Hi,

Thank you.
will try setting encoding in my.cnf and then report id it works.

Greetings