search

FirebirdSQL / firebird

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

Cannot open FDB file when folder path includes character code of 0x5c. [CORE4993] #1974

Open firebird-automations opened 9 years ago

firebird-automations commented 9 years ago

Submitted by: Tatsuya Saito (saito)

Is related to CORE316 Is related to CORE2172

Cannot open FDB file with following condition.

<Steps to reproduce> 1. Put FDB file on following path. C:\test表z\TEST.FDB 2. Create following folder. C:\test 3. Open FDB file using isql command. C:\test表z>isql test.fdb -u user -p password Statement failed, SQLSTATE = 08001 I/O error during "CreateFile (open)" operation for fi -Error while trying to open file -指定されたパスが見つかりません。 Use CONNECT or CREATE DATABASE to specify a database

* "指定されたパスが見つかりません。" means "specified path not found".

<Expected Behavior> Success to open FDB file.

<Actual Behavior> Failed to open it like above.

<Operating System> OS:Windows 7 Professional 64bit Firebird:2.5.2.26540(Win32) FDB Charset: CP943C

<Information> * Success to open it when "C:\test" folder is not exist. * Success to open it when folder path does not include character code of 0x5c. * "表" is Japanese character. The code is 0x955c on Shift-JIS. On Shift-JIS character code set, 0x5c means "\" which is separator of folder path.

firebird-automations commented 9 years ago
Modified by: Tatsuya Saito (saito) description: Cannot open FDB file with following condition\. 1\. Put FDB file on following path\. C:\\test表z\\TEST\.FDB 2\. Create following folder\. C:\\test 3\. Open FDB file using isql command\. D:\\test表z\>isql test\.fdb \-u user \-p password Statement failed, SQLSTATE = 08001 I/O error during "CreateFile \(open\)" operation for fi \-Error while trying to open file \-指定されたパスが見つかりません。 Use CONNECT or CREATE DATABASE to specify a database \* "指定されたパスが見つかりません。" means "specified path not found"\. Success to open FDB file\. Failed to open it like above\. OS:Windows 7 Professional 64bit Firebird:2\.5\.2\.26540\(Win32\) FDB Charset: CP943C \* Success to open it when "C:\\test" folder is not exist\. \* Success to open it when folder path does not include character code of 0x5c\. \* "表" is Japanese character\. The code is 0x955c on Shift\-JIS\. On Shift\-JIS character code set, 0x5c means "\\" which is separator of folder path\. =\> Cannot open FDB file with following condition\. 1\. Put FDB file on following path\. C:\\test表z\\TEST\.FDB 2\. Create following folder\. C:\\test 3\. Open FDB file using isql command\. C:\\test表z\>isql test\.fdb \-u user \-p password Statement failed, SQLSTATE = 08001 I/O error during "CreateFile \(open\)" operation for fi \-Error while trying to open file \-指定されたパスが見つかりません。 Use CONNECT or CREATE DATABASE to specify a database \* "指定されたパスが見つかりません。" means "specified path not found"\. Success to open FDB file\. Failed to open it like above\. OS:Windows 7 Professional 64bit Firebird:2\.5\.2\.26540\(Win32\) FDB Charset: CP943C \* Success to open it when "C:\\test" folder is not exist\. \* Success to open it when folder path does not include character code of 0x5c\. \* "表" is Japanese character\. The code is 0x955c on Shift\-JIS\. On Shift\-JIS character code set, 0x5c means "\\" which is separator of folder path\.
firebird-automations commented 9 years ago
Modified by: Tatsuya Saito (saito) environment: Windows 7 Professional 64bit =\> Windows 7 Professional 64bit \(Japanese\)
firebird-automations commented 9 years ago
Modified by: Sean Leyne (seanleyne) Link: This issue is related to [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 9 years ago
Modified by: Sean Leyne (seanleyne) Link: This issue is related to [CORE2172](https://github.com/FirebirdSQL/firebird/issues?q=CORE2172+in%3Atitle) \[ [CORE2172](https://github.com/FirebirdSQL/firebird/issues?q=CORE2172+in%3Atitle) \]
firebird-automations commented 8 years ago

Commented by: Tatsuya Saito (saito)

Related issues of CORE2172 is not reproduced on my environment, I can open problem path fdb.

In my case, another folder like C:\test is needed to occur it. If not exist the folder, I can open it.