هذا حل مشكلة الرسائل البريدية بعد الترميز
كود:
ALTER TABLE `mailqueue` CHANGE `toemail` `toemail` MEDIUMTEXT CHARACTER SET cp1256 COLLATE cp1256_general_ci NULL DEFAULT NULL ,
CHANGE `fromemail` `fromemail` MEDIUMTEXT CHARACTER SET cp1256 COLLATE cp1256_general_ci NULL DEFAULT NULL ,
CHANGE `subject` `subject` MEDIUMTEXT CHARACTER SET cp1256 COLLATE cp1256_general_ci NULL DEFAULT NULL ,
CHANGE `message` `message` MEDIUMTEXT CHARACTER SET cp1256 COLLATE cp1256_general_ci NULL DEFAULT NULL ,
CHANGE `header` `header` MEDIUMTEXT CHARACTER SET cp1256 COLLATE cp1256_general_ci NULL DEFAULT NULL
وهذا للرسائل الخاصة
كود:
ALTER TABLE `pmreceipt` CHANGE `tousername` `tousername` VARCHAR( 100 ) CHARACTER SET cp1256 COLLATE cp1256_general_ci NOT NULL ,
CHANGE `title` `title` VARCHAR( 250 ) CHARACTER SET cp1256 COLLATE cp1256_general_ci NOT NULL
و
كود:
ALTER TABLE `pmtext` CHANGE `fromusername` `fromusername` VARCHAR( 100 ) CHARACTER SET cp1256 COLLATE cp1256_general_ci NOT NULL ,
CHANGE `title` `title` VARCHAR( 250 ) CHARACTER SET cp1256 COLLATE cp1256_general_ci NOT NULL ,
CHANGE `message` `message` MEDIUMTEXT CHARACTER SET cp1256 COLLATE cp1256_general_ci NOT NULL ,
CHANGE `touserarray` `touserarray` MEDIUMTEXT CHARACTER SET cp1256 COLLATE cp1256_general_ci NOT NULL
تحية طيبة