How to enter the Indian Rupee symbol in MySQL Server 5.1?

Question

I am unable to find the exact solution for MySQL

Answer 1

The thing is the column supports by default UTF-8 encoding which consists of 3 bytes. The Indian Rupee Symbol, since it is new has a 4 byte encoding. So we have to change the character encoding to utf8_general_ci by,

ALTER TABLE test_tb MODIFY COLUMN col VARCHAR(255)
    CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL;

After executing the above query simply execute the following query to insert the symbol,

insert into test_tb values("₹");

Ta-Da!!!