Subject | Re: [firebird-support] Input of special characters in isql not possible |
---|---|
Author | Stefan Heymann |
Post date | 2006-11-28T12:41:45Z |
Koczian,
there seem to be some things mixed up, even in your e-mail, which is
encoded as ISO-8859-1 and contains UTF-8 characters.
In Firebird, the character set name for UTF-8 is UTF8 (without the
dash sign). In Firebird 1.5 ISQL you should try UNICODE_FSS as the
client character set.
SET NAMES UNICODE_FSS;
HTH
Regards
Stefan
Stefan Heymann
www.destructor.de/firebird
there seem to be some things mixed up, even in your e-mail, which is
encoded as ISO-8859-1 and contains UTF-8 characters.
In Firebird, the character set name for UTF-8 is UTF8 (without the
dash sign). In Firebird 1.5 ISQL you should try UNICODE_FSS as the
client character set.
SET NAMES UNICODE_FSS;
HTH
Regards
Stefan
> I'm using firebird 1.5.3, OS is Linux (Ubuntu 6.10). The default--
> character set of my database is ISO8859_1, the default character set
> of the system is UTF-8.
> When testing queries in isql I can't enter special characters (ä, ö,
> ü, � and the like) at all - I just get a beep, no character. Changing
> the character set in the terminal doesn't help, entering "set names
> ISO8859_1' or "set names UTF-8" doesn't help.
> The keyboard setting is german (without "nodeadkeys"). Working in the
> terminal I can enter special characters, only in isql that doesn't work.
> How can I change this?
> Thank you,
> Koczian
Stefan Heymann
www.destructor.de/firebird