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) CHARACTER SET utf8 COLLATE utf8_bin NULL DEFAULT NULL , CHANGE COLUMN `vchAccount` `vchAccount` VARCHAR(200) CHARACTER SET utf8 COLLATE utf8_bin NULL DEFAULT NULL , CHANGE COLUMN `vchReceiversign` `vchReceiversign` VARCHAR(4000) CHARACTER SET utf8 COLLATE utf8_bin NULL DEFAULT NULL ;
Now enjoy this read.
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)
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) CHARACTER SET utf8 COLLATE utf8_bin NULL DEFAULT NULL , CHANGE COLUMN `vchAccount` `vchAccount` VARCHAR(200) CHARACTER SET utf8 COLLATE utf8_bin NULL DEFAULT NULL , CHANGE COLUMN `vchReceiversign` `vchReceiversign` VARCHAR(4000) CHARACTER SET utf8 COLLATE utf8_bin NULL DEFAULT NULL ;
Now enjoy this read.
By Manoj.( ????? ??????
alternative link download
