Recently on Dec. 11th 2006, upon my university MySQL server restarted , all "Arabic" entries sent to our university discussion board has been mis-behaving
#issue:
* before the restart,
using the default IE/firefox "western ISO 8859-1" or "unicode UTF-8" encoding was able to view all the "arabic" entires stored in the database [by automatically adjusting page encoding to "unicode-UTF8"] and no need to use the "Arabic windows 1256" encoding manually
example: on Dec. 7th 2006
http://img156.imageshack.us/img156/3087/beforegp0.jpg
* after the restart ,
neither the default IE/firefox "western ISO" nor "unicode UTF-8" encodings able to view any of NEW "arabic" entries properly
example: on Dec 16th 2006
http://img72.imageshack.us/img72/4153/afteryu4.jpg
Solution:
students have to manually shift to "Arabic windows 1256" to be able to view any Arabic text [stored in database after Dec 11th] correctly
P.S: we have not make any changes to our MySQL, php settings ,its still the same since Nov.
[only daily optimization processes are done]
--
MySQL info:
# Server version: 4.1.21-standard-log
# Protocol version: 10
# MySQL charset: UTF-8 Unicode (utf8)
# MySQL connection collation: utf8_unicode_ci
database snap shot
http://img90.imageshack.us/img90/2553/collationdc7.jpg
# php 4.4.4
--
any idea What's wrong ? and how to fix !
Thanks in advance
Edited 2 time(s). Last edit at 12/25/2006 09:51PM by DaHiA ...
