Arabic Language 1

[JKingdom]

i have an ASP page and Access database ..

i can enter data to the database in arabic and retrieve them in arabic as will through the explorer but when i open the access database i see the records in strange letters in the tables!! .. only the records that i entered from the explorer looks like that .. but the records that i enter from the database itself looks normal in the database and when i want to retrieve them in the explorer they look like question marks !!!

so whats the problem and whats the solution

 

[Sheco]

Does it look like what happens if you use notepad or some other text editor to open a file that is not a text file? Or like when you open a regular text file as if it was in unicode? Somethng like this?

 

[Chopstik]

You may also want to try the search functionality here at Tek-Tips. Use the word "Arabic" as your search criteria and it populates 10 related questions in this forum alone. You may find some of them useful.

------------------------------------------------------------------------------------------------------------------------
"I am not young enough to know everything."
Oscar Wilde (1854-1900)

 

[MichaelRed]

AFAIK, when Ms. A. saves info to a record, it is just the "ASCII" for the characters. When you change the "Language" (code page?) the values representing the various characters changes along with the symbology of the characters. To "Translate" the character representations correctly, you need to store the code page (Language) used to create (ENTER) along with the information which was entered NAD use this information to display the characters. e,g, If you use arabic to enter the info, use arabic to read it. The concept of translating the content from one language to another simply by storing it in ons language and retrievieng it in another is not available yet. (and may not be for a considerable period of time -despite the universal communicators used throughout most of the "Start Trek" media).




MichaelRed

 

[adolsun]

I faced the same problem with my db long time ago and I’ve made a tricky way to fix it. I opened an old Arabic db (MS Access XP) I used earlier and amend it to match my new db requirement. It’s not a professional way but at last your db will work.

Make sure that your computer sitting is right.

 

[JKingdom]

the caracters looks like this .. ÚÈÏÇááå

now is there anyway that i can get the normal caracters back .. coz i wana convert it to be on the sql server .. but it converts is as it is .. !!

 

[adolsun]

Have you checked that you have Arabic code on your pages?

Here's the code:

<%@LANGUAGE="VBSCRIPT" codepage="1256"%>

 

[JKingdom]

i have this ...

<meta http-equiv="Content-Type" content="text/html; charset=windows-1256">

 

[adolsun]

No, this's different ... try it on the top of each page. The script language must recognise the page code (Arabic).

Good luck.

 

[JKingdom]

i'll give it a try .. thanks ..

 

[JKingdom]

when i pasted this ..

(<%@LANGUAGE="VBSCRIPT" codepage="1256"%>) on the top of the page .. the Arabic Characters changed to be another strange Characters that the sql doesn;t recongnize .. i mean when i want to search or when i have statments like bla bla = bla bla ..
before pasting that line i used to get the arabic normal but when its saved in the database it looks strange abd when retrieving its normal as well .. but in the Access it self looks strange .. the page saves it in that way in access .. coz if i tried to type in access directory its normal but when retrieving looks wierd ,,

so .. is there any other way ??

 

[JKingdom]

by the way .. when i pasted this code and then typed through the database .. then retrieved in the page it didn't appear strange like before (????) it gave me the arabic and when i inserted through tha page its the same as well normal .. so the problem solved .. but how to get my old records that inserted earlier in the database back to normal ???

 

[adolsun]

To fix it, I need to know the following:

1. Are you storing your date manually (via MS Access) or you have a front end (ASP forms) to store it?

2. When you open your MS Access, can you see a difference between your old and new data?

3. When you open your ASP pages, can you see a difference between your old and new data?

 

[JKingdom]

1. ASP form .. (before using the code u gave me .. thats why it looked strange) now its storing fine ,,

2. yeah there is a different .. the new looks normal arabic .. the old looks strange..

3. with the line u gave me i can see the new record normally but the old strange .. and with out the code u gave me i can see the old normally and the new strange ..

so the line u gave me was great .. but the problem is with the old records in the database .. i need to change them in teh database to be normal so i can retrieve them normal with the line u gave me ..

 

[adolsun]

Bill Gates isn't Arab ! so, the Arabic language's still not strong enough. In your case I'm not sure this time, but I think as the data you've entered earlier was unrecognized by the code page (courrepted), I'm afraid to say that you need to re-enter your data again. You can use copy+paste to minimize your time.

 

[JKingdom]

aha .. doesn't sound interesting .. but what to do !

 

[JKingdom]

woow .. found a fast way of coping and pasting ..

i have 8 columns in teh databse i did this for each :

1. copied the column from the table.. (Strange characters)

2. pasted it in front page. saved the page then opened in in the browser. (still Strange characters).

3. changed the encoding to arabic(windows) ... (got the normal characters back)

4. copied the colunm from the webpage
5. pasted back in the database ...


for those who have to use the way i used .. be careful from the empty fields .. pefore coping .. type any letter in the empty field and then u can remove it by (Fine/Replace) once u r done


thanks for those who tried to help and who helped ..

thanks (*(*(*(*(adolsun)*)*)*)*) for the line u gave me it solve my prb of insertig strange data ..