Hi everyone,
I am connecting to a postgresql database (version 10) over the network
using the new jdbc driver (42.2.2). The DB's character set is LATIN1, my
system is UTF8, both machines run debian stable.
I don't manage to display the characters correctly when running a select
on the database (squirrelsql result shows "für" instead of "für" for
example). I did not find any option to specify the character set,
moreover, the driver specification says that it's not necessary anymore.
For years all worked fine with an oracle database (latin1) and the
oracle driver, but lately we switched to postgres and now I cannot use
squirrelsql anymore (pg4admin and psql-client display the characters
correctly).
Does anyone has an idea what I am missing?
Thanks,
Peter
|