Re: Arabic MySQL Perl

From: Marco Cimarosti (
Date: Mon Feb 19 2001 - 07:33:46 EST

George Zeigler wrote:
> my company is creating sites in multiple languages with pages being
> dynamically. The words are pulled into the pages from a MySQL database.
> programs are written in Perl. Our programmers cannot figure out how to
> Arabic and Hebrew working (right -> left languages). From what I've been
> the data is stored properly in MySQL . But getting the right -> languages
> appear in the dynamically loaded pages only gives garbage.
> Any one have any experience in this are? Or is it necessary to do
> completely seperate programs?

What Arabic and Hebrew encodings are used to store text in your database?

Does the HTML header of your generated web pages properly specify the *same*

To specify the document's encoding in an HTML file, you should add somewhere
inside the <HEAD>...</HEAD> a line like this:

        <META http-equiv="Content-Type" content="text/html;

Where I wrote "YourEncodingGoesHere", you should insert the identifier for
the encoding that you are using.

For Arabic, your encoding is probably one of these: iso-8859-6, ASMO-708,
DOS-720, windows-1256, x-mac-arabic.

For Hebrew, the most likely candidates are: iso-8859-8, iso-8859-8-i,
DOS-862, windows-1255, x-mac-hebrew.

For both languages you might be using Unicode, of course. Depending on the
UTF used, Unicode could correspond to one of these identifiers: utf-8,
unicode, utf-16, unicodeFFFE, utf-7.

See <> for more info
about this.

Also see
.asp> for an unofficial list of character sets that may be used in web

Moreover, you might need to specify the language and/or directionality of
parts of the page, especially if you have pages with multiple languages, or
if you are using complex layout (tables, etc.). See
<> for more info about this.

Hoping this helps.
_ Marco

This archive was generated by hypermail 2.1.2 : Tue Jul 10 2001 - 17:21:19 EDT