Hi Ghanshyam,

> Can anybody tell me ,which character set is to be used for adding
> the values '€','¥','£'

These characters (Euro Symbol, Yen Symbol, Pound Sterling Symbol)
are all found in
ISO-8859-15
Windows CP1252
UNICODE_FSS

Giving current Firebird implementation, CP1252 would be the
best fit.

But if these are the only non-ASCII characters in the database,
you may be better served by doing the character mapping
in your front end application and store standard three character
codes (EUR, JPY, GBP) and/or Unicode Codepoint numbers (0x20AC,
0x00A5, 0x00A3) in your database.

Regards,
Peter Jacobi