--- In Firebird-Java@y..., "rrokytskyy" <rrokytskyy@y...> wrote:
Thanks alot. I've got it going Ok now.

Ryan


> Sorry, that should be ISO8859_1.
>
> Might be. There are one issue when you have charset specified:
> Firebird should know how to convert characters from the charset
> specified for connection to charset specified for column and vice
> versa. Some rules are (just from my experiance and docs):
>
> - Firebird knows how to convert from UNICODE_FSS to any;
> - Firebird _does not_ know how to convert NONE to any;
> - Firebird might know how to convert from A to B and might not.
>
> This means:
>
> - If you do not specify the charset for database and for columns,
it
> is automatically NONE and your connection charset should be NONE
too.
>
> - If your connection has charset NONE, you can select from any
> column, but you cannot write to columns, that have charset other
than
> NONE.
>
> - If your connection has charset other than NONE, you can
read/write
> only those columns, where Firebird is able to convert characters.
>
>
> So, I would suggest following:
>
> - set some default charset for database;
> - use "lc_ctype=UNICODE_FSS".
>
> or
>
> - drop all charset definitions;
> - use "lc_ctype=NONE".
>
> This should work.
>
> Best regards,
> Roman Rokytskyy