Subject | Charset for external table filename |
---|---|
Author | Kjell Rilbe |
Post date | 2013-06-18T12:44:13Z |
Hi,
I just tried to create an external table with a filename that contains
"ö". The database charset is UTF-8 and I did it from FlameRobin using
UTF-8 as connection character set.
It failed because the filename obviously got encoded as UTF-8, and
passed like that to the server's file system, resulting in a filename
with "ö" instead of "ö".
This can't be right...
How is this supposed to work and how am I supposed to get it right?
I would have thought that the Firebird server would be aware that the
string literals it receives from the client are encoded in the
connection charset, and transliterate to the file system's charset
before trying to create/access the file. Am I missing something?
Regards,
Kjell
--
--------------------------------------
Kjell Rilbe
DataDIA AB
E-post: kjell@...
Telefon: 08-761 06 55
Mobil: 0733-44 24 64
I just tried to create an external table with a filename that contains
"ö". The database charset is UTF-8 and I did it from FlameRobin using
UTF-8 as connection character set.
It failed because the filename obviously got encoded as UTF-8, and
passed like that to the server's file system, resulting in a filename
with "ö" instead of "ö".
This can't be right...
How is this supposed to work and how am I supposed to get it right?
I would have thought that the Firebird server would be aware that the
string literals it receives from the client are encoded in the
connection charset, and transliterate to the file system's charset
before trying to create/access the file. Am I missing something?
Regards,
Kjell
--
--------------------------------------
Kjell Rilbe
DataDIA AB
E-post: kjell@...
Telefon: 08-761 06 55
Mobil: 0733-44 24 64