Subject | Re: iso8559_1 from windows / linux |
---|---|
Author | woodwardtimothy76 |
Post date | 2008-02-20T22:06:10Z |
> Within linux and flamerobin I can acces data with right latinsOne way to see if this is the case is to try executing the following
> 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?
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