Hello

 

I have a default postgresql installation (UTF8).

My client is running with latin1.

 

Why the client encoding are different?

Are there special settings for the iodbc driver?

 

Thx

 

Martin

 

[nemadm@harry-test ~]$ locale -v

LANG=en_US.iso88591

LC_CTYPE=en_US.iso88591

LC_NUMERIC="en_US.iso88591"

LC_TIME="en_US.iso88591"

LC_COLLATE="en_US.iso88591"

LC_MONETARY="en_US.iso88591"

LC_MESSAGES="en_US.iso88591"

LC_PAPER="en_US.iso88591"

LC_NAME="en_US.iso88591"

LC_ADDRESS="en_US.iso88591"

LC_TELEPHONE="en_US.iso88591"

LC_MEASUREMENT="en_US.iso88591"

LC_IDENTIFICATION="en_US.iso88591"

LC_ALL=

 

[nemadm@harry-test ~]$ psql -d NEM_DATABASE -c "show client_encoding"

client_encoding

-----------------

LATIN1

(1 row)

 

[nemadm@harry-test ~]$ iodbctestw

Driver Manager: 03.52.0709.0909

SQL>show client_encoding

 

client_encoding              

------------------------------

UTF8