Win32 - Can't connect database placed in a directory with Japanese characters [CORE2172]

[firebird-automations]

Submitted by: James Ang (jang)

Duplicates CORE316
Is duplicated by CORE3172
Relate to CORE4993

Votes: 5

The Firebird FDB is placed in this folder:
C:\日本語フォルダ\Data\

Hence the full path to the FDB is:
C:\日本語フォルダ\Data\FIREBIRDSUPERSERVERALIAS.FDB

Calls to isc_attach_database() will fail with something like "Unspecified database name".

I reproduced this issue on my development environment (Windows XP Professional SP3 (US English locale)), but the problem was found while testing on a Japanese OS.

I can also reproduce the problem with an FDB named: 日本語フォルダ.FDB placed in C:\
C:\日本語フォルダ.FDB

It was very easy to reproduce the problem.

The workaround is to ensure that the full path to the FDB does not contain non-ASCII characters especially Unicode characters.

This problem was found in the versions of Firebird I tested (specified in this bug report else where).

[firebird-automations]

Modified by: Sean Leyne (seanleyne)

status: Open [ 1 ] => Resolved [ 5 ]

resolution: Duplicate [ 3 ]

[firebird-automations]

Modified by: Sean Leyne (seanleyne)

Link: This issue duplicates CORE316 [ CORE316 ]

[firebird-automations]

Modified by: @pcisar

status: Resolved [ 5 ] => Closed [ 6 ]

[firebird-automations]

Commented by: @asfernandes

I'm reopening this case, because it may be fixed only when we use the Windows Wide API functions.
It's not a duplicate report.

[firebird-automations]

Modified by: @asfernandes

status: Closed [ 6 ] => Reopened [ 4 ]

resolution: Duplicate [ 3 ] =>

[firebird-automations]

Modified by: @asfernandes

Link: This issue is duplicated by CORE3172 [ CORE3172 ]

[firebird-automations]

Commented by: @aafemt

This issue is not limited to Japanese characters but appear on any path or file name containing symbols from outside of current ANSI code page. And using CreateFileW() indeed is necessary to solve it on Windows. On Linux fopen accepts utf-8 encoded string.

[firebird-automations]

Commented by: @asfernandes

It depends on Windows ANSI codepage. If it's UTF-8, and using the new utf8-dpb, it should work.

[firebird-automations]

Modified by: Sean Leyne (seanleyne)

Link: This issue relate to CORE4993 [ CORE4993 ]

[firebird-automations]

Commented by: @aafemt

UTF-8 cannot be set as ANSI codepage in Windows.