Subject Re: [firebird-support] Unicode (finnish) characters in win isql script file
Author Helen Borrie
At 08:54 AM 28/07/2004 +0100, you wrote:
>Hello,
>
>I have defined Firebird database (in win environment) to use UNICODE_FSS
>characters. Now I am using sql script files with "isql - i
>scriptfile.sql"-way to put initial data to the database. But I have
>problems when trying to add special finnish characters like ä and ö.
>
>There was discussion in this forum about using lc_ctype UNICODE_FSS when
>connecting to database but how could this be defined when using scripts ?
>
>Hope someone knows the answer to this question how to input data with isql
>scriptfiles that contain special characters.
>
>BR,
>Marika
>
>My start of the script file is...
>CONNECT '.\..\aardb.GDB' USER 'SYSDBA' PASSWORD 'jotain';
>INSERT into ...

Start the script with a SET NAMES command:
SET NAMES UNICODE_FSS;
CONNECT........

/heLen