DB and Date data type

[Medi Montaseri]

Hi,

I was wondering how Date data type is dealt with in such databases
as PostgreSQL or mySQL?

Databases usually have Date related operations such as equality,
less than, greater than, etc . But most databases have the Gregorian
Calendar and not Jalalian.

Any solutions or hacks?

Thanks
Mehdi
___
PersianComputing mailing list
PersianComputing@lists.sharif.edu
http://lists.sharif.edu/mailman/listinfo/persiancomputing

info@farsiweb.info

[Medi Montaseri]

Hi,

I have emailed [EMAIL PROTECTED] over a week ago with no reply/avail.
Anyone knows of any other way to contact farsiweb.info folks.

I had some contribs

Thanks
Mehdi
___
PersianComputing mailing list
PersianComputing@lists.sharif.edu
http://lists.sharif.edu/mailman/listinfo/persiancomputing

Re: Date data type in MySQL

[Medi Montaseri]

Thanks Mohsen...On 6/5/05, mohsen ali momeni [EMAIL PROTECTED] wrote:
 Hi, I was wondering how Date data type is dealt with in such databases as PostgreSQL or mySQL? Databases usually have Date related operations such as equality, less than, greater than, etc . But most databases have the Gregorian
 Calendar and not Jalalian. Any solutions or hacks?Jalali calender is not implemented in MySQL yet. But MySQL doesn'tcheck the validity of Date entered. I mean you can enter any date
having day part from 1 to 31. So Jalali Date can be saved in Date datatype of MySQL. Also operations such as equality or .. works fine withit. The only problem is the Add_Date, Sub_Date and functions like that
which doesn't work for Persian Date. A Multi-Calender system for MySQLis going to be developed in near future (probably by me) so if youneed the full functionality, you should wait till then.Regards,
--__ \ /_\\_-//_ Mohsen A. Momeni __\ _ /_ www.momeni.us.tc___PersianComputing mailing list
PersianComputing@lists.sharif.eduhttp://lists.sharif.edu/mailman/listinfo/persiancomputing
___
PersianComputing mailing list
PersianComputing@lists.sharif.edu
http://lists.sharif.edu/mailman/listinfo/persiancomputing

Jalali.pm Ver 1.2 with Farsi Support

[Medi Montaseri]

Hi,

I just released Jalali.pm ver 1.2 available at http://montaseri.net/download

Briefly, Jalali.pm is a Perl Module for Jalalian and Gregorian calander conversion
and Time Traveling (N days ago, N days ahead, etc). Version 1.2 also supports 
FArsi and ENglish, such that you can get things like

$obj = Jalali - new ( -Lang = 'FA' );
$Today = $obj-getTodaysDate();
print $Today \n;

And you'll get

یکشنبه ۲۰ شهریور ۱۳۸۴

Or you can say
$Today = $obj- getTodaysDate( ' Greg ');
print $Today \n;

An you 'll get

یکشنبه ۱۱ سپتامبر ۲۰۰۵

Behdad please update FarsiWeb at your discretion.

Thanks

___
PersianComputing mailing list
PersianComputing@lists.sharif.edu
http://lists.sharif.edu/mailman/listinfo/persiancomputing

Bad Farsi Fonts or something

[Medi Montaseri]

Hi 
I am having some problems with my Farsi fonts on my browser and in gedit 
on a Linux box (Fedor Core 4, Gnome )

My problem is 

Letter Ye is always rendered as though it was an independent or
detatched letter. For example, in the word MILI (as in mili-second) all the
Ye letters are rendered as it would with MEHDI where ye is not
connected to de.


Some help is appreciated.
Thanks
Medi
___
PersianComputing mailing list
PersianComputing@lists.sharif.edu
http://lists.sharif.edu/mailman/listinfo/persiancomputing