On 2/7/2016 4:06 AM, Burkhardt Renz wrote:
> That’s right.
> But if I enter ß on the keyboard or from the clipboard,
> psql takes this as 0x03 0x77 instead of 0xc3 0x97.
that must be a mac osx or something because thats sure not a valid UTF8
code.
pierce=# select 'ß', encode('ß', 'hex');
?column? | encode
----------+--------
ß | c39f
(1 row)
pierce=# show client_encoding;
client_encoding
-----------------
UTF8
(1 row)
and in linux shell,
$ locale charmap
UTF-8
--
john r pierce, recycling bits in santa cruz