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:

SQL> SET NAMES 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.)

./heLen