To comment on the following update, log in, then open the issue:
http://www.openoffice.org/issues/show_bug.cgi?id=55609
Issue #:|55609
Summary:|The HSQLDB seems not to work with non ASCII directory
|names
Component:|Database access
Version:|OOO 2.0 Beta2
Platform:|All
URL:|
OS/Version:|All
Status:|NEW
Status whiteboard:|
Keywords:|
Resolution:|
Issue type:|DEFECT
Priority:|P3
Subcomponent:|none
Assigned to:|dbaneedsconfirm
Reported by:|tora
------- Additional comments from [EMAIL PROTECTED] Fri Oct 7 04:38:42 -0700
2005 -------
Problem
A database file xxxx.odb for HSQLDB in a directory whose
name includes non ASCII letters seems not to work properly.
This phenomenon can be probably observed with recent
OpenOffice.org, StarOffice, and StarSuite on any platforms.
Phenomenon, however, might be slightly different depending
on the platform you use.
The following instructions are based on the results with
StarSuite 8 Japanese build 680m124(Build:8945) running on
Solaris 10 3/05 x86 with LANG=C.
Reproduction
(Scenario A)
1. Create a new database file in the default work directory.
2. Make a table and fill it with some records.
3. Close the database file.
4. Open it and confirm if the table exists.
It should be there.
5. Create a directory whose name includes non ASCII letters
e.g. Bücher
I created this directory through the File > Save As
dialogue window with Special Characters that appears
by clicking a right button on the text box for the name.
6. Copy the original database file into the new directory.
7. Open the copied database file through File > Open
8. Confirm if the table exists.
You may notice the fact that the table created in the
step 2 above disappear.
In addition to the missing table, you may find an unknown
directory named B?cher next to the directory Bücher.
A lock file could be find in the directory B?cher instead
of the expected directory Bücher.
9. Close the database file.
10. Copy the original database file into the unexpected
directory called B?cher.
11. Open it through File > Open
12. Cofirm if the table exists.
Now you may find the original table that was missing in
the step 8 above.
(Scenario B)
1. Create another new database file and save it in the
directory Bücher.
2. Create a table and fill it with some records.
3. Close it.
4. Open it.
5. Confirm if the table still exists.
You may find the fact that the table has gone.
After working with the steps above, give a glance at the insides:
Archive: ./New Database.odb
Length Date Time Name
------ ---- ---- ----
28 10-07-05 00:09 mimetype
2903 10-06-05 22:37 content.xml
277 10-07-05 00:09 database/script
94 10-07-05 00:09 database/backup
402 10-07-05 00:09 database/properties
152 10-07-05 00:09 database/data
616 10-06-05 22:37 settings.xml
931 10-07-05 00:09 META-INF/manifest.xml
------ -------
5403 8 files
That looks perfect!
Archive: ./Bücher/NewDatabase2.odb
Length Date Time Name
------ ---- ---- ----
28 10-07-05 00:09 mimetype
0 10-07-05 00:09 META-INF/
2564 10-06-05 22:46 content.xml
402 10-07-05 00:09 database/.properties
92 10-06-05 22:54 database/.backup
152 10-07-05 00:09 database/.data
323 10-07-05 00:09 database/.script
616 10-06-05 22:46 settings.xml
1013 10-07-05 00:09 META-INF/manifest.xml
------ -------
5190 9 files
What is the letter period as in database/.properties ?
Archive: ./Bücher/New Database.odb
Length Date Time Name
------ ---- ---- ----
28 10-06-05 23:00 mimetype
0 10-06-05 23:00 META-INF/
2903 10-06-05 22:37 content.xml
397 10-06-05 22:37 database/log
403 10-06-05 22:37 database/properties
402 10-06-05 23:00 database/.properties
0 10-06-05 22:37 database/data
100 10-06-05 23:00 database/.script
616 10-06-05 22:37 settings.xml
1096 10-06-05 23:00 META-INF/manifest.xml
------ -------
5945 10 files
What is going on!
Acknowledgments
This phenomenon was originally reported by Masafumi Kamataki
and he conducted deep investigations.
He used a Japanese variant of OpenOffice.org 1.9 and faced
missing tables when he copied a database file into another
folder whose name had Japanese characters on Windows.
Thanks to Kamataki, now we can reproduce this phenomenon
in a more general way.
---------------------------------------------------------------------
Please do not reply to this automatically generated notification from
Issue Tracker. Please log onto the website and enter your comments.
http://qa.openoffice.org/issue_handling/project_issues.html#notification
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
