[Fedora-trans-ar] Do we have any Web Developers within?

[Munzir Taha]

-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1

في يوم السّبت 29 رجب 1426 10:19, كتب Mohammad Ghoniem:
> Maha Helwa wrote:
> > Ghoniem.. don't u know about that Arabic issue in the db.. how to
> > insert them with the right encoding and how to read them properly?
>
> As far as I know, the db needs to be in UTF-8 to handle Arabic
> correctly. Try creating your db in UTF-8 from the beginning i.e. do not
> alter the tables to be in UTF-8 afterwards. I will be doing some tests
> in shâ'a Allâh.

Ghoneim and all, can you clarify this point please?
1. Why creating db in UTF-8 from the beginning is different than altering it 
to be UTF-8 afterwards?
2. I just imported some arabic UTF-8 database sql file to mysql and the php 
script displays them properly (with encoding cp1256). mysql status command 
shows
Server characterset:    latin1
Db     characterset:    latin1
Client characterset:    latin1
Conn.  characterset:    latin1
how come latin1 and still it works is beyond my knowledge. When should I care 
to chnage these defaults then and why? I am not experienced enough here so 
please keep it simple ;)

- -- 
Munzir Taha
Telecommunications and Electronics Engineer
Maintainer of Fedora Arabic Translation Project
https://listman.redhat.com/mailman/listinfo/fedora-trans-ar
Maintainer of the OpenBugs project page at
http://www.arabic-fedora.org/munzir/OpenBugs.html
Master CIW Designer, ICDL, MOUS, Linux+, LPI 101
New Horizons CLC, Riyadh, SA
-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.4.0 (GNU/Linux)

iD8DBQFDIbomOBlicvBnGCERAjCqAKCAyC/dL5etUmVnlchyz4PRxBlVeACfRPwY
CJN+xwy+O5PgjIzEd4aNPKA=
=o55V
-----END PGP SIGNATURE-----