KXEH2Y6F

1CREATE DATABASE sinhala_test;
2USE kindheart;
3
4ALTER DATABASE sinhala_test
5CHARACTER SET  utf8  
6COLLATE utf8_general_ci
7
8CREATE TABLE IF NOT EXISTS `category` (
9  `category_id` INT(11) UNSIGNED NOT NULL AUTO_INCREMENT,
10  `name_si` VARCHAR(100) COLLATE utf8_unicode_ci NOT NULL,
11  `description_si` TEXT COLLATE utf8_unicode_ci NOT NULL,
12  `last_update` TIMESTAMP NULL DEFAULT CURRENT_TIMESTAMP,
13  PRIMARY KEY (`category_id`)
14) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
15
16INSERT INTO `category` VALUES (1,'පොත් පත් සහ පාසල් උපකරණ','නවතම පොත් පත් අවශ්‍යතා ඇතුළු සියළුම පාසැල් හා අධ්‍යාපන මෙවලම්.',NOW());
17	
18mysql> select * from categoryG
19*************************** 1. row ***************************
20   category_id: 1
21       name_si: ???? ??? ?? ????? ?????
22description_si: ???? ??????? ????/ ?????? ?? ?? ???? O/L, A/L ??????? ?????, ???????, ??????? ????? ?????? ???? ??? ????????. ????/???????/???????????/??????/?????? ????/ ????/????/?????? ????? ?????? ?????? ?? ???????? ??????.
23   last_update: 2018-05-20 11:11:20