Subject Re: iso8559_1 from windows / linux
Author woodwardtimothy76
> 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