At 07:18 PM 17-05-02 +0800, you wrote:

>Hi All,
>
>I'am beginner in Firebird-Java group.
>I have problem in create SQL script for unicode,
>can someone help, and give me sample code.
>
>for example, I want to do this:
>
>INSERT INTO TEST (UNICODE_FSS_FIELD) VALUES ('¼/ –, ')
>or
>INSERT INTO TEST (UNICODE_FSS_FIELD) VALUES (' GJ 'D4A1) 'DEH-/) JHFPCH/ )
>
>Please, I need help

there are two requirements:
1) the column must be declared as CHARACTER SET UNICODE_FSS
2) the data being placed in the column must be unicode. If this is not
possible through your keyboard, you can insert your keyboard's characters
and "cast" them into unicode using the _UNICODE_FSS marker:

INSERT INTO TEST (UNICODE_FSS_FIELD) VALUES ( _UNICODE_FSS ' ?? ??????
??????? ??????? )

(sorry for the ????, my mail client won't do your sample characters).

regards,
Helen

All for Open and Open for All
Firebird Open SQL Database · http://firebirdsql.org ·
http://users.tpg.com.au/helebor/
_______________________________________________________