Arbic Data Text in mySql Database Table
Arbic Data Text in mySql Database Table Some time we need this type of requirement as per the client given. I have faced this one. But need not to worry there are lots of way by which we can insert data/text into mysql table. Create a table with following steps:- 1. Create a table with Collation - utf8- utf8-bin 2. Then , set all columns datatype should be varchar and Collation - utf8- utf8-bin 3. And now Apply changes. Ok This above image setting for table. This image for setting column . (utf-8-to-column.jpg) This image , finally data inside the table. (data-in-table.jpg) Or by using query column_name varchar(50) character set utf8 collate utf8_bin ----set for individual column CHARSET=utf8 ---------Set on table Below one dummy query for better understanding- ALTER TABLE `admin_kairali`.`t_report_language` CHANGE COLUMN `vchBeing` `vchBeing` VARCHAR(200) CHARACTER SET utf8 COLLATE utf8_bin NULL DEFAULT NULL , CHANGE COLUMN `vchScrtry` `vchScrtry` VARCHAR(200...