alhakeem2001,
your db is utf-8 swedish_ca , I have asked you to check, I did't ask you to change it.
if you change the general db collection type, that will not change your db collection type., it will change it for future created tables only, you will have to go table by table, and field by field in each existing table and change the collection type, our use SQL commands to do this.
this maybe not cause damages with english data characters, but for sure it will corrupt your arabic inserted data, so you have to be carfull when do this things and you must know what you are doing, it might look easy to you to change the collection type, and hit go, but sometimes, it has many unexpected consequnces.
I think you need to leave your db collection type as it is, utf-8 swedish ca for everything table feilds and the db default collection type, and change other things accordingly.
or ( do not do this now )
delete your db, create new db, set the defalut db collection type to utf-8_general_ca before the installation.
re-install zen-cart, with option of inserting sample data.
didn't do this as I am on my work now, I will do this later today, but would that fix the writing direction and will flip around the boxes for the Arabic language?
no it will not, language pack got thing to do with page layout direction, you Must use rtl template, use the one i sent to you before.
One more remark here, is the Arabic fonts look ok in the admin side when I use the Arabic language, but when I use any other language English… the fonts turn to funny symbols ! how can I avoid that ?
becuase when you choose english in admin area, charset reading is getting changed according to the admin/includes/languages/english.php
check charset parameter in admin/includes/languages/english.php file, and make sure it is the same charset as admin/includes/languages/arabic.php.