search

FirebirdSQL / firebird

Firebird server, client and tools
https://www.firebirdsql.org/
1.26k stars 217 forks source link

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

Open firebird-automations opened 16 years ago

firebird-automations commented 16 years ago

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 commented 16 years ago
Modified by: Sean Leyne (seanleyne) status: Open \[ 1 \] =\> Resolved \[ 5 \] resolution: Duplicate \[ 3 \]
firebird-automations commented 16 years ago
Modified by: Sean Leyne (seanleyne) Link: This issue duplicates [CORE316](https://github.com/FirebirdSQL/firebird/issues?q=CORE316+in%3Atitle) \[ [CORE316](https://github.com/FirebirdSQL/firebird/issues?q=CORE316+in%3Atitle) \]
firebird-automations commented 16 years ago
Modified by: @pcisar status: Resolved \[ 5 \] =\> Closed \[ 6 \]
firebird-automations commented 15 years ago

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 commented 15 years ago
Modified by: @asfernandes status: Closed \[ 6 \] =\> Reopened \[ 4 \] resolution: Duplicate \[ 3 \] =\>
firebird-automations commented 14 years ago
Modified by: @asfernandes Link: This issue is duplicated by [CORE3172](https://github.com/FirebirdSQL/firebird/issues?q=CORE3172+in%3Atitle) \[ [CORE3172](https://github.com/FirebirdSQL/firebird/issues?q=CORE3172+in%3Atitle) \]
firebird-automations commented 11 years ago

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 11 years ago

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 commented 9 years ago
Modified by: Sean Leyne (seanleyne) Link: This issue relate to [CORE4993](https://github.com/FirebirdSQL/firebird/issues?q=CORE4993+in%3Atitle) \[ [CORE4993](https://github.com/FirebirdSQL/firebird/issues?q=CORE4993+in%3Atitle) \]
firebird-automations commented 8 years ago

Commented by: @aafemt

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