PDA

View Full Version : Asp datetime problem with non-Unicode languages



neon20
03-05-2007, 02:42 PM
hi everybody,

i have datetime problem with my access database

im not able to update the datetime field in the msaccess table using

objcon.execute "update users set us_userlastlogin='" & now() & "' where us_userid= '" & us_userid & "'"


i have non-Unicode language as Arabic in Regional and Language Option in the control panel. When i change this to US english eerything works fine.

But if it is arabic, the query is works as

update users set us_userlastlogin='03/03/2007 05:44:21 م' where us_userid= 'anas'

instead of

update users set us_userlastlogin='03/03/2007 05:44:21 PM' where us_userid= 'anas'

ie the datetime field doesnt accept م character

is there any convert or alternative methods for this?

thank you
neon