MySQL Language Charset & UTF-8

[daredevil14]

Greetings everyone,

well, i've been working on an arabic guestbook based on MySQL & PHP, the MySQL charset on localhost is UTF-8, and the meta of the view_book.php page is UTF-8 as well, so everything is perfect...

the problem is that when i uploaded the guestbook to the webhost, and pasting the MySQL code on the phpmyadmin of my webhost... i can't change the charset of the phpmyadmin to UTF-8, so the arabic language when viewing the guestbook is not supported, unless i right click and change the encoding, but of course, it won't be like every visitor will right click and change the encoding...

so is there any way that i can alter some php code / or / change the html charset to something that can communicate with the db and displays an arabic language ? ( without editing the charset of MySQL of my webhost - because i can't i guess )

Cheers

[cahva]

If your host's phpmyadmin has wrong configuration, you can just install your own phpmyadmin with prefered settings.

BTW, it isnt wise to paste the sql, use the file upload if possible(theres option to select the charset in that also)