I've used LO for quite a few years, but never touched the Base part. Recently I tried my hands on it, but found it not working at all under my non-privileged user account with a Chinse (non-Latin) user name on Windows 10.
Steps to Reproduce:
There are two symptoms:
1. Creating a new database in LO Base, after choosing options (don't register the database in the system, everything else default) in the wizard, the save file dialog pops out and asks for a file name. After entering the file name, the dialog window disappears and the following error message dialog pops out:
*I/O error during "CreateFile (create)" operation for file "C:\USERS\<Chinese User Name>\APPDATA\LOCAL\TEMP\LU1624462CC3W.TMP\LU1624462CC40.TMP\FIREBIRD"
*Error while trying to create file
(My user name is redacted as it's my real name. The scrambled characters are just as shown on my screen.)
After this error no operation on the database seems possible.
2. Opening an existing database in LO Base, the following error message pops out:
*cannot open backup file C:\Users\<Scrambled Characters>\AppData\Local\Temp\lu1624462cc3w.tmp\lu1624462cc3z.tmp/firebird.fbk
*Exiting before completion due to errors
(Here the path doesn't exist, as the <Scrambled Characters> part is not my user name. Since my user name has two characters and this scrambled part has three, I suspect there is some UTF-8 to UCS-2 conversion issue here.)
Under the administrative account with a English user name, Base seems to work fine on the surface.
I'm not sure the two symptoms are connected, so let me know if I need to file a separate bug.
Base is not usable for users with Chinese account names.
Base works for every account.
User Profile Reset: No
This issued existed for 6.2.1, and I've recently reproduced in 6.2.4 RC1. The "About" information is as follows:
Version: 220.127.116.11 (x64)
Build ID: 170a9c04e0ad25cd937fc7a913bb06bf8c75c11d
CPU threads: 2; OS: Windows 10.0; UI render: GL; VCL: win;
Locale: zh-CN (zh_CN); UI-Language: en-GB
Well, so far I've only been able to look at this on Linux and on a machine set for English. Using LO 6.3 Beta 1
I tried this:
Created a directory: 预算
Created a Base (Firebird embedded) file named 预算 and stored it in that directory. No problem.
Added a table named 支付 with columns 键, 量 and 日期. Again with no problems.
So that is not a really satisfactory test - I'll see about getting a Chinese character account on a Windows 10 machine and try it all there. Beyond that I need to reach out to someone on the Chinese mailing lists for help in checking this.
(In reply to Drew Jensen from comment #1)
> Well, so far I've only been able to look at this on Linux and on a machine
> set for English. Using LO 6.3 Beta 1
> I tried this:
> Created a directory: 预算
> Created a Base (Firebird embedded) file named 预算 and stored it in that
> directory. No problem.
> Added a table named 支付 with columns 键, 量 and 日期. Again with no problems.
Not that it's an important difference, but I'd like to comment that my problem comes from a Chinese *user account name*, not necessarily a Chinese directory.
I don't think there is anything comparable on Linux though. A Chinese $HOME (/home/预算 for example) maybe, but I don't think Linux allows non-ascii username yet.
(In reply to Ming Hua from comment #2)
> (In reply to Drew Jensen from comment #1)
> I don't think there is anything comparable on Linux though. A Chinese $HOME
> (/home/预算 for example) maybe, but I don't think Linux allows non-ascii
> username yet.
Indeed, I made the same test as Drew (see comment 1) in Win10 with master sources updated today, no problem to create the file and reopen it.
Drew and Julien, thanks for looking into this bug.
I did exactly the same test in comment #1 on my computer under the English-named administrative account with LO 6.2.4. No problems as well.
So yeah, that's probably not a satisfactory test.
One more data point -- I can reproduce both problems on Win10 with LO 6.3.0 beta2.
Both problems are still reproducible in 6.4.0 beta1.
Version: 18.104.22.168.beta1 (x64)
Build ID: 4d7e5b0c40ed843384704eca3ce21981d4e98920
CPU threads: 2; OS: Windows 10.0 Build 18363; UI render: default; VCL: win;
Locale: zh-CN (zh_CN); UI-Language: en-US
Similar report from a Japanese user.
On pc Debian x86-64 with master sources updated today, I created a new user with non ascii characters and I don't reproduce this so I suppose it's indeed Windows only.
Here's a codepointer to start:
172 m_sFirebirdURL = m_pDatabaseFileDir->GetFileName() + "/firebird.fdb";
173 m_sFBKPath = m_pDatabaseFileDir->GetFileName() + "/firebird.fbk";
I suppose "m_pDatabaseFileDir->GetFileName()" is ko but can't tell more.
We need someone who can build sources on Windows and who has a non ascii profile directory.
Stephan: comparing method osl_getFileURLFromSystemPath sal/osl/unx/file_url.cxx and sal/osl/w32/file_url.cxx, I noticed Unix version used RTL_TEXTENCODING_UTF8 and Windows version RTL_TEXTENCODING_ASCII_US, is it expected?