Subject | How to determine the true charset of database content? |
---|---|
Author | skoczian |
Post date | 2008-12-09T11:30:37Z |
Hello,
I think I may have put data with the wrong character set into a
database table. No problem, because the database is for testing
things anyway, but how can I see what really is in there? Doesn't
each client transliterate the data? Even with connection charset
NONE, what about the terminal itself?
Firebird 2.1.1.17910.0 on Gentoo Linux
Besides ISQL I could use FlameRobin 0.8.6 or Python with kinterbasdb
3.2.2.
System charset is UTF8, database default charset is ISO8859_1, the
problem column is using this.
Thank you,
Herta
I think I may have put data with the wrong character set into a
database table. No problem, because the database is for testing
things anyway, but how can I see what really is in there? Doesn't
each client transliterate the data? Even with connection charset
NONE, what about the terminal itself?
Firebird 2.1.1.17910.0 on Gentoo Linux
Besides ISQL I could use FlameRobin 0.8.6 or Python with kinterbasdb
3.2.2.
System charset is UTF8, database default charset is ISO8859_1, the
problem column is using this.
Thank you,
Herta