--- In firebird-support@yahoogroups.com, "woodwardtimothy76"
<woodwardtimothy76@...> wrote:

>
> > Within linux and flamerobin I can acces data with right latins
> > characters (accents), but if I run flamerobin from a windows box I
> > can't get the right characters. I tested with all charsets combination
> > in the connection settings. I think data were created in UTF8 way and
> > from windows it can't handle in the proper way. Is that right?
>
> One way to see if this is the case is to try executing the following
> query:
>
> select
> FIELD1
> from
> TABLE1
> where
> octet_length(FIELD1) <>
> char_length(FIELD1)
>
> where FIELD1 in TABLE1 is the field that you suspect contains utf-8

data.

>
> If this query returns any records then you probably have utf-8 data.
>
> I hope it helps,
> Tim Woodward
>

Sorry, I just realised that this is not going to work :(

However you could try a query such as the following:

select
FIELD1
octet_length(FIELD1)
from
TABLE1

Look at the records where FIELD1 contains accented characters.

If octet_length is different to the number of characters in FIELD1,
then FIELD1 contains utf-8 data.

I hope it helps,
tim