External table file names not transliterated to OS character set
----------------------------------------------------------------
Key: CORE-6202
URL: http://tracker.firebirdsql.org/browse/CORE-6202
Project: Firebird Core
Issue Type: Bug
Components: Engine
Affects Versions: 3.0.4
Environment: Windows 64 bit with OS character set Windows-1252
Reporter: Kjell Rilbe
Priority: Minor
It seems that the file name specified for an external table is sent to the
operating system's file operations without transliteration. This makes it
impossible to use file names with non-ASCII characters.
For example, specifying the file name 'Teståäö.txt' will result in a file named
'Teståäö.txt'. Which is the Win-1252 interpretation of the byte sequence
that UTF-8 string 'Teståäö.txt' is encoded as.
In other words, it would appear that the file name, stored in UTF-8
(UNICODE-FSS?) format is sent as is to a Windows system call that expects the
file name to be encoded in the operating system's codepage, in this case
Win-1252.
I've tried this in both isql and FlameRobin and got consistent results. The
file name appears correct in RDB$RELATIONS.RDB$EXTERNAL_FILE but ends up wrong
in the operating system, like described above.
I expect this to be rather easily fixed, considering the file name is always
stored in the same character set (UTF8, or is it UNICODE_FSS?) and the
operating system's character set is known. All that should be needed is to add
transliteration of the stored file name before sending it to any operating
system call.
By the way, I think I've had similar issues with database file name, but have
not tried it recently. Maybe it would be a good idea to go through all
operating system file operations and make sure the file name(s) passed are
properly transliterated.
--
This message is automatically generated by JIRA.
-
If you think it was sent incorrectly contact one of the administrators:
http://tracker.firebirdsql.org/secure/Administrators.jspa
-
For more information on JIRA, see: http://www.atlassian.com/software/jira
Firebird-Devel mailing list, web interface at
https://lists.sourceforge.net/lists/listinfo/firebird-devel
