Hi, friends..
in this post i found a code which is listed below.
i facing some problem in PHP/SQL to store special charecter or other languages in database. When we save data in varchar datatype field then it show ?????. so after googling i found this code. i change field data type VarChar to varbinary so that data is store into binary form. and when i retrive data then i change datatype of data to varbinary to varchar by using this code...
i using CONVERT function
CONVERT(`name`, CHAR(255)) as `name` -> name is field name..
SELECT `groupId`, CONVERT(`name`, CHAR(255)) as `name`, `image`, `type`, `status`, CONVERT_TZ(`addedDate`,'-6:00','".$zone."') as `addedDate` FROM `msg_user_group` WHERE `groupId` = 1;
in this post i found a code which is listed below.
i facing some problem in PHP/SQL to store special charecter or other languages in database. When we save data in varchar datatype field then it show ?????. so after googling i found this code. i change field data type VarChar to varbinary so that data is store into binary form. and when i retrive data then i change datatype of data to varbinary to varchar by using this code...
i using CONVERT function
CONVERT(`name`, CHAR(255)) as `name` -> name is field name..
SELECT `groupId`, CONVERT(`name`, CHAR(255)) as `name`, `image`, `type`, `status`, CONVERT_TZ(`addedDate`,'-6:00','".$zone."') as `addedDate` FROM `msg_user_group` WHERE `groupId` = 1;