Subject Re: three byte unicode characters
Author Roman Rokytskyy
Hi,

> I've just started with FB and I wonder if it is possible to populate
> UNICODE_FSS fields with that characters that are coded with at least
> three bytes like musical symbols (http://www.unicode.org/charts/,
> several latest codecharts) with setString method of
> PreparedStatement object.
> ...
> As far as I understood (with my English) Java is capable to carry
> more-than-two-byte characters in String, for example (it will use that
> "surrogate pairs" to escape 3-byte chars). May I hope that JayBird
> will automatically be able to put such a string into UNICODE_FSS
> field?

UNICODE_FSS is a synonym for UTF-8 encoding. JayBird will correctly
convert Java unicode string into UTF-8 (it uses Java conversion
routines, so as long as Java can convert stuff correctly, JayBird can
as well). So, if your characters can be represented in the UTF-8
encoding, you will have no problems of correctly reading and writing
them into the database. Just be sure that you set "lc_ctype"
connection parameter to "UNICODE_FSS" and ensure that your database
column has UNICODE_FSS character set.

Best regards,
Roman Rokytskyy