> We had some code something like this
>
> sqlBuffer.append("_UNICODE_FSS '");
> if (temp != null)
> {
> sqlBuffer.append(escapeSQLQuotes(temp));
> }
> sqlBuffer.append("'");
>
> Here temp contains the string to be appended. We insert this string
> into the database.

Appending "_UNICODE_FSS" does not make string to be saved in UNICODE
encoding. In fact, it will be stored used in the encoding specified in
the database (either database default character set, or character set
for that column). There's also notion of connection encoding, that's
the encoding in which data are sent for the application. Please read
JayBird's FAQ on this topic.

Roman