besaraha.. ana mesh merakeza khals..bas i'll tell you what i did..
I think there is a default values for the charset.. which is the key point here..
when u use insert statement into a table with arabic data.. and u did not adjust the encoding of the table u already define.. the data will be rabish not save properly.. that's the problem i faced at the time i sent that email..
all u have to do is to define a table taking into consideration the charset.. bas da men nahya..
another thing.. when u display that data.. am talking from Jsp side or java desktop application side.. you also should take into consideration the charset to be UTF-8 or any other arabic encodings bas maybe it won't work properly on other enviroments.. 3shan keda utf-8..
 
ana mesh merakeza kalas...
 
On 9/9/05, Munzir Taha <munzirtaha@gmail.com> wrote:
-----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-----

--
Fedora-trans-ar mailing list
Fedora-trans-ar@redhat.com
http://www.redhat.com/mailman/listinfo/fedora-trans-ar