Subject Re: [firebird-support] isql keyboard input problem
Author Helen Borrie
At 08:07 PM 29/09/2004 +0000, you wrote:
>I run isql on Linux Fedora 2.
>My locale (LANG environment variable) is sv_SE.UTF-8
>isql -z gives:
>ISQL Version: LI-V1.5.1.4481 Firebird 1.5
>My problem is that I can't input Swedish characters like åäöÅÄÖ
>No character is entered when I press the keys. I use a Swedish keyboard.
>However it is possible to enter them if I do EDIT and enter a SQL
>statement through my default "vi" editor.
>The characters also displays correctly if I do a select on tuples
>containg such characters.
>Is this a know bug? Is there some setting or flag I should apply?
>Currently I just start isql by typing isql from the command line with
>no parameters.

In isql, use the command SET NAMES to set the client character set to the
same character set as the default charset of the database. There is no
command-line switch to do this.

For example, if the default charset is unicode_fss:


Note, you also have to do this in isql scripts and client applications. In
client applications the ISQL language set isn't available - you need a
connection setting that resolves to the database parameter
isc_dpb_lc_ctype. How it's surfaced depends on the API interface you are
using (Java, PHP, etc.)