how to store Arabic data

[Guest]

Hi all

Iam developing an application on win ce.net for teklogix terminal for english as well as arabic languages using sql ce data base. Please let me know how to store arabic data in the sql ce data base.

Thanks & regards
Vamsi

 

[Mark Johnson]

Since the Framework DateTime as well as the Datbase DateTime are based on
the Gregory Calendar, this will be a problem.

The non-Gregory Calendars are Moon based as apposed to the Sun based Gregory
Calendar.
Not to mention the Problen which base year to start with...

The three major Moon Calendars I have worked with (Jewish, Christian and
Isamic) have 3 different bases.
No doubt there are many Asian Calendars also base on the Moon Calendar with
different bases.

The number of days per year are also different due to difference of the leap
year convention.

The most precise was the Aztek (Sun based if I remember correctly), but
very unpractible for Computers.
I played around with that a few years ago and failed to get correct results.

Do Arab and Israelie Computers support there Calendar Systems?

Mark Johnson, Berlin Germany
(e-mail address removed)

Hi all

Iam developing an application on win ce.net for teklogix terminal for

english as well as arabic languages using sql ce data base. Please let me
know how to store arabic data in the sql ce data base.

 

[Mark Johnson]

Maya and not Aztek of cource, sorry

Since the Framework DateTime as well as the Datbase DateTime are based on
the Gregory Calendar, this will be a problem.

The non-Gregory Calendars are Moon based as apposed to the Sun based Gregory
Calendar.
Not to mention the Problen which base year to start with...

The three major Moon Calendars I have worked with (Jewish, Christian and
Isamic) have 3 different bases.
No doubt there are many Asian Calendars also base on the Moon Calendar with
different bases.

The number of days per year are also different due to difference of the leap
year convention.

The most precise was the Aztek (Sun based if I remember correctly), but
very unpractible for Computers.
I played around with that a few years ago and failed to get correct results.

Do Arab and Israelie Computers support there Calendar Systems?

Mark Johnson, Berlin Germany
(e-mail address removed)



english as well as arabic languages using sql ce data base. Please let me
know how to store arabic data in the sql ce data base.

 

[Mark Johnson]

Having thought about this problem and after a look at the source code for
the Framework DataTime Class,
I see no reason why a Arab version of DateTime could not be written.

I would of cource need a set of the official rules, as set by the Koran no
doubt, to judge this exactly.
From my basic knowlage of the Moon Calendar I see no problem here.
But if I remember correctly, there are certin regulations as to when the
month starts accourding to where the moon rises at certin points. This of
cource could hinder a mathamatical solution.

If you could supply these regulation that are accepted generly in the Arab
world, then I would consider accepting a commission to to this, if offered.

The DateTime stored in a Database is basicly a number - it would be up to
program reading it to interpid the meaning of this number.

Recieving and Sending a Gregory/Islamic equation should be no problem.

Send me an E-Mail if you are interested in solving this interesting
Internationaltion Problem. (German or English)

Mark Johnson, Berlin Germany
(e-mail address removed)

Hi all

Iam developing an application on win ce.net for teklogix terminal for

english as well as arabic languages using sql ce data base. Please let me
know how to store arabic data in the sql ce data base.

 

[Paul G. Tobey [eMVP]]

It seems like textual data should be handled by simply encoding it in
Unicode, rather than with 8-bit characters. You'll have to handle the
reading direction and so on somehow, but the base data should just work, I
think.

Paul T.

Hi all

Iam developing an application on win ce.net for teklogix terminal for

english as well as arabic languages using sql ce data base. Please let me
know how to store arabic data in the sql ce data base.