I changed the charset set but does not work
CREATE TABLE `tbl_hindi` (
`data` varchar(1000) character set utf8 collate utf8_bin default NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
INSERT INTO `tbl_hindi` VALUES ('à¤à¤à¤ªà¥à¤¯à¥à¤à¤°');
The charset of the database needs to be utf8_unicode_ci
.
Try creating a new database, as well as a new table.
CREATE DATABASE hindi_test
CHARACTER SET utf8
COLLATE utf8_unicode_ci;
USE hindi_test;
CREATE TABLE `hindi` (
`data` varchar(200) COLLATE utf8_unicode_ci NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
INSERT INTO `hindi` (`data`) VALUES
('à¤à¤à¤ªà¥à¤¯à¥à¤à¤°');
This works on my install. If it doesn't work for you, something might be wrong with your server settings.