Mix in encoding...
Posted in 2007
Jean Georges Perrin — — source: Usenet: comp.databases.informix
Hi, I am running an engine which we want to be en-us.utf-8 (we want it that way to have the maximum flexibility over ANY character set, if we are wrong, please advice). Nevertheless, we have a couple of apps that uses it fine, setting DB_LOCALE and SERVER_LOCALE. Unfortunately, one app (to rename nameless ;-) but not one of ours), has modified "some" of the data and now we get plenty of "java.sql.SQLException: Encoding or code set not supported." Of course, things like DBexport because our tables are too big. Can I convert all my fields to UTF8? Is there some kind of magical tool out there? jgp