how can we make arabic web site?

[zahidpervaiz]

Hello,
Dear Friends,
I have to make such type of interface,you can say it a html form.
in which a admin can write arabic data and can insert that data or recordsin database in ASP.
and i have to make a show.asp in which user can see that arabic data
in table from database on internet.

FOR english version i have make that project completely.

but i have to make that project in arabic also.
Actually client want this project in english and as well as in
arabic.
so that admin can insert data in arabic also.
I will upload that web site on internet.
i know how to insert data and how to show data from database.

but the problem is that,i don't know what r the requirments
to insert arabic data in database on internet and what r the requirments to
show arabic data in table from data base.

Please tell me in detail for this purpose.
I have make all web sites in english this is ist time that i have to make
arabic web site.
so??????????????????????????/

I shall be very thankful to you for this purpose.

ZAHID.

 

[ehsant]

Hi...
actually, you don't have to have any special requirments...
you can have 3 type of arabic pages and data...
I mean 3 diferent type of character sets...
1- windows-1256
2- Unicode
3- User defined
number 3, is an old way and by now, it's rarely used...
but 1 and 2 are the two well knowns...
in windows 98 arabic versions, the code page was 1256
but in win2k and winxp the code page is unicode...
so, we can say thet in future we will just have Unicode...
the only thing you have to do is to set the codepage of your HTML page to unicode or utf-8
and you laso have to set your database characterset to unicode too if you are using SQL server...
but if you are usin access, for the Text and Memo datatypes, you have a Unicode compression that you have to set them to yes(the default value of them are yes too)
that's it...
now you have an arabic web site...

----
TNX.
E.T.

 

[zahidpervaiz]

Thanks,
Bundle of thanks,
Please can u send me an example that
save record in arabic IN ACCESS DATABASE
and also one file that show arabic in table.
just simple files.
Please tell me i'm new in asp.
and just got job in asp.
so Please........
BYE.
ZAHID.

 

[ehsant]

Hi...
as I Said, you don't need anything special to store or retrieve data to/from database...
you just use the code for english data for storing data to DB and retrieving it from db...
you just need to set the character set/Code page of your page to 1256 Or unicode...
here is the samples
for 1256 :
<META http-equiv=Content-Type content=&quot;text/html; charset=windows-1256&quot;>
and for unicode :
<META http-equiv=Content-Type content=&quot;text/html; charset=unicode&quot;>
Or :
<META http-equiv=Content-Type content=&quot;text/html; charset=UTF-8&quot;>
and you HAVE to put these codes inside your Head tags...
and for the font, which everybody can see the arabic chars(even in win98 Eng) you can use Tahoma
that's it...
now you have an arabic site ...

----
TNX.
E.T.

 

[zahidpervaiz]

My Dear,
It is not working.I have used these meta tags
one by one.
but still records show in english not in arabic.
zahid.

 

[ehsant]

Hi...
I don't understand what you really want to do ?
I think it's impossible to insert an arabic word in DB and retrieve it in english...
when you put these meta tags in your code, when your page is loading, it tell the browser that the codepage of this page is for example 1256 and the browser sets the Encoding of the page to arabic(windows)...
by setting he code page to 1256, it only goves the ability you the browser to show the arabic 1265 chars on the screen...
then you have to have a windows that has the arabic language to be able to input arabic chars by it...

but here is a sample...

http://www.printpoints.net/arabic/test.asp

and also all the files are here for download...

http://www.printpoints.net/arabic/Arabic.zip

the two files FarsiConv.asp and KeyMap.asp are not really required but as you see, these two files just convert unicode to 1256 and vise versa...
one is client side and one is server side...
because maybe there be someone with an english windows that wants to type arabic(farsi) data in the browser, i have a client side function which gets the input and convert them to the farsi chars...
hope be helpful...

----
TNX.
E.T.

 

[rudejohn]

Ehsant I thought it was funny on that

http://www.printpoints.net

website, it says &quot;Sing In&quot; instead of &quot;Sign in&quot;. Is that your site?

Also, I was trying to follow this thread just for my own curiosity and I got a database error when I clicked your link.

RJ

************
RudeJohn
************

 

[ehsant]

Hi...
1- printpoints.net is not my web site...
I just got the hosting for one of my friends...
2- I don't know what had happened to to the database but I had to download it and repair it...
but, know its working...
that's funny... I'll tell my friend to replace the SING IN button with sign in... thanks for your attention rudejohn ...

----
TNX.
E.T.

 

[zahidpervaiz]

Hello Ehsant,
Thanks Bundle of Thanks.Just tell me last question about
ARABIC.
Dear tell me.If i want to change whole web site.
in arabic from english.
I meaan i want to give facility to uae people.
My client want this facility.
I'm new in asp 3.0
if they want to see whole web site in english.
they will click on english button if they want to see
that whole web site in arabic. they will click
on arabic button.
for english it is ok.
If they click on arabic button then how can i
change whole contents of web site( which is in english)
into arabic also some database records which are showing in
tables.
Please tell me, this is my last question about this topic to you.
ok.
TAKE CARE AND BYE.
ZAHID.

 

[ehsant]

Hi...
1- You have a tag with the name of DIR which by default for english pages its LTR but you can change it to RTL for your arabic pages...
so you can add dir=&quot;rtl&quot; to yhe body of your pages...
2- you have to translate all your english words to arabic and put them in your pages...
3- you can create a field in your tables with the name of for example Arabic which if it was 1 the record is arabic and if it was 0 it is english...
so you still have youe Prev. tables and if you want to query your tables for english pages, you have to ad this condition WHERE Arabic = 0 and for arabic pages WHERE Arabic = 1 to your queries...
thats it...
and as i said, you can use Tahoma font for arabic, which its general and every windows has it...
but remember, Netscape doen't support codepage 1256 and if your site has netscape visitors, you only have the chioce of Unicpde codepage...

----
TNX.
E.T.

 

[zahidpervaiz]

Hello,
Thanks,
Your 1,and 3 points i have done.but 2nd one i did not know
how can i translate all english words to arabic and put them in pages...Please tell me,if possible then send me little examples.
Bye.
zahid.

 

[ehsant]

Hi...
I don't know...
maybe you can fin a translator and give the words to him to translate them for you or, As it seems, you english well, so maybe you, yourself can do the translation ...
or mayby, you can find some software to translate the arabic text to english...
a while ago I saw a web site

http://www.ajeeb.com

which you gave the address of the english site to it and it translates all the data to arabic and show the site to you in arabic...
maybe they can help you ...

----
TNX.
E.T.

 

[zahidpervaiz]

Thanks....