insert ≠ (not equal to ) in mysql field

Question

I run the following query in mysql

UPDATE `gamequestions` SET a2 = '≠' WHERE id = 564

It runs successfully but the '?' is inserted in a2 field in place of '≠'

The datatype of a2 is text and also tried with varchar

Any Help greatly appreciated.

Answer 1

you need to change Collation to UTF-8 to store special characters

Answer 2

insert ≠ (not equal to ) in mysql field

The goal in these conversions is always to decide on what charset/collation combination you want to use (UTF8 being the best choice in almost all scenarios) then to convert all tables/columns in your database to use that charset. At that point you can set DB_COLLATE and DB_CHARSET` to the desired charset and collation to match.

Note:

In most cases if a collation is not defined MySQL will assume the default collation for the CHARSET which is specified. For UTF8 the default is utf8_general_ci, which is usually the right choice.

Changing the default charset of the database

ALTER DATABASE MyDb CHARACTER SET utf8;

Changing the default charset of individual tables

ALTER TABLE MyTable CHARACTER SET utf8;

https://dev.mysql.com/doc/refman/5.1/en/charset-unicode-utf8.html

Answer 3

You can add that option in the /mysql/my.cnf. In the [mysqld] section add ’’character-set-server=UTF8"; in the [client] section add “default-character-set=UTF8”.

You can find more information in these links: http://dev.mysql.com/doc/refman/5.1/en/charset-… http://dev.mysql.com/doc/refman/5.0/en/server-o…

If you need to conver existing data, you can execute:

ALTER TABLE tbl_name CONVERT TO CHARACTER SET charset_name; 

Answer 4

You need to check following things

use set names utf8 before you query/insert into the database

using Default CHARSET=utf8 when creating new tables