--- In firebird-support@yahoogroups.com, "peter_jacobi.rm"
<peter_jacobi@g...> wrote:

> --- In firebird-support@yahoogroups.com, "macauit" <macauIT@h...>

wrote:

> > My sample table is as following:
> > The insert statement succeeded but the text in the table was

encoded

> > incorrectly as ('?' has been replaced instead)
>
> When the insert succeeds, perhaps the problem is with the
> select?
>
> Do you provide a connection character set?
>
> Do you look at the results with something that is UTF-8 aware?
>
> Regards,
> Peter Jacobi

I just found out the problem was because I used the non-Unicode
IBConsole to testify _UNICODE_FSS in Insert-statement under Windows.
As IBConsole is non-Unicode, the program always uses the default
system locale to translate text. Thus '?' will be encoded to replace
all characters not fit into the system locale setting.


Regards

MacuaIT