Issue 57784

Summary:

database created in MS XP, date field, returns wrong value in Linux (Fedora)

Product:

Base

Reporter:

abonnema <abonnema>

Component:

code

Assignee:

dbaneedsconfirm <needsconfirm>

Status:

CLOSED WONT_FIX

QA Contact:

issues@dba <issues>

Severity:

Trivial

Priority:

CC:

andrew, issues

Version:

OOo 2.0

Keywords:

needmoreinfo

Target Milestone:

---

Hardware:

OS:

All

Issue Type:

DEFECT

Latest Confirmation in:

---

Developer Difficulty:

---

Attachments:

Description	Flags
the database in question	none

Description abonnema 2005-11-12 11:56:46 UTC

I created a database with a date field using Windows XP. When using Linux I want
to read and update the same database, but I get 01/01/1970 for each date in
stead of the date I entered in Windows.

I run Windows X64 (64 bits version of XP) and Fedora Core 4.

If usefull I will send the database to the person that is researching this. It
is quite a small database (one record with around 5 occurrences).

Bonnema, Leiden.

Comment 1 abonnema 2005-11-12 11:57:35 UTC

Created attachment 31414 [details]
the database in question

Comment 2 abonnema 2005-11-12 12:01:22 UTC

(I suspect the previous description was lost somehow).

I created a database from Windows X64 containing a date field and defined a form
to enter some data. Then I restarted into Linux (Fedora core 4) and started to
read and/or update the database. However every date entered is represented as
01/01/1970. 

Returning to Windows I get the originally entered date back.

Guus Bonnema, Leiden.

Comment 3 andrew 2005-11-14 05:39:06 UTC

Using FC 3, I downloaded the ODB document. The migraine table indicates that 

"The data content can not be loaded"

The other table is empty, but it can be loaded. Can someone else verify that
data does exist in the migraine table when loaded under windows?

Comment 4 Frank Schönheit 2005-11-14 11:11:25 UTC

tried Solaris Sparc, SUSE 9.2, Win XP, with OOo 2.0 (680m3): the "migraine" can
be opened and properly displays the dates.

What's your system locale, abonnema?

Comment 5 abonnema 2005-11-15 03:54:31 UTC

fs, thanks for checking.

I am not completely sure how to check locale in Fedora Core , but the language
is English(USA). Is that sufficient information?

The date was originally entered with the (Dutch) layout, dd-mm-yyyy, from XP. 

Guus Bonnema, Leiden, The Netherlands.

Comment 6 Frank Schönheit 2005-11-15 08:06:45 UTC

Not completely sure, too ... :-\
Try
  setenv | grep LC_
(or "set | grep LC_", depending on your shell)
and tell the environment variables which it gives you.

Comment 7 christoph.lukasiak 2006-02-14 13:42:01 UTC

set keyword: needmoreinfo

Comment 8 abonnema 2006-02-15 17:09:22 UTC

I have included the output from the command 'locale':

LANG=en_US.UTF-8
LC_CTYPE="en_US.UTF-8"
LC_NUMERIC="en_US.UTF-8"
LC_TIME="en_US.UTF-8"
LC_COLLATE="en_US.UTF-8"
LC_MONETARY="en_US.UTF-8"
LC_MESSAGES="en_US.UTF-8"
LC_PAPER="en_US.UTF-8"
LC_NAME="en_US.UTF-8"
LC_ADDRESS="en_US.UTF-8"
LC_TELEPHONE="en_US.UTF-8"
LC_MEASUREMENT="en_US.UTF-8"
LC_IDENTIFICATION="en_US.UTF-8"
LC_ALL=

P.S. I apologize for not reacting immediately.

Comment 9 christoph.lukasiak 2006-06-12 15:36:50 UTC

does this problem still occure in current version
(http://download.openoffice.org/680/index.html) - please acknowledge

thx

Comment 10 abonnema 2006-06-12 19:47:10 UTC

=== SOLVED ==========

I run oobase from Fedora Core 5 and the problem using Fedora has vanished!

Thanks, guys. I very much appreciate your efforts!

Guus Bonnema, Leiden, The Netherlands.

Comment 11 christoph.lukasiak 2006-07-04 15:30:30 UTC

wontfix

Comment 12 christoph.lukasiak 2006-07-04 15:31:24 UTC

close