Subject Re: [firebird-support] iso8559_1 from windows / linux
Author Milan Babuskov
yartax1 wrote:
> I have a FB 1.5 database created in a debian linux distro with
> Flamerobin app. The database is created with ISO8859_1 default charset
> and all char fields and domains are too.
>
> Within linux and flamerobin I can acces data with right latins
> characters (accents), but if I run flamerobin from a windows

Which version of Windows? XP? Is it US/English, or some other?

> can't get the right characters. I tested with all charsets combination
> in the connection settings. I think data were created in UTF8 way

If you created the database with charset ISO8859_1 it should be
ISO8859_1 and not UTF8. UTF8 is just the charset of user interface and
FlameRobin does all the transliterations back and forth.

> from windows it can't handle in the proper way. Is that right?

It should. If your data is ISO8859_1 and connection charset is also
ISO8859_1 and you're using FlameRobin 0.8.1 or newer, FlameRobin should
do the proper transliteration between connection charset and your
default Windows charset.

Please note that if you used FlameRobin versions lower than 0.8.1 to
enter the data, then data is most probably NOT in ISO8859_1, but in
UTF8. This was a bug that was fixed in 0.8.1.

You can easily use CAST(column_name as char(nnn) character set OCTETS)
to see the actual bits and bytes that are stored and then compare that
with real character codes from ISO8859_1 or UTF8 table.

As this seems to be FlameRobin related, you're welcome to continue
discussion at our mailing-list:

https://lists.sourceforge.net/lists/listinfo/flamerobin-devel

--
Milan Babuskov
http://www.flamerobin.org