Get Arabic to appear correctly in both static HTML and database text
I am trying to get my asp classic vbscript page to render Arabic script correctly.
I can get the HTML to display the Arabic characters correctly by simply adding the following line at the top:
This works for all Arabic script within HTML and all response.write calls that do not pull text from the database.
<html dir="rtl" lang="ar" xml:lang="ar" xmlns="http://www.w3.org/1999/xhtml">
However when the Arabic text is pulled from the access database, it comes up as a bunch of wierd symbols, see the example here:
I tried adding this to the top of the page:
This fixes the text that is pulled from the database but it screws up all the Arabic symbol in the regular HTML text on the page, see the example here:
Session.LCID = 1032
Session.CodePage = 1256
So how do I encode the page so that both the Arabic in the HTML text and that is pulled from the database appears correctly?