On 7/30/2017 1:19 PM, Igor Korot wrote:
I am using a database for my project that I created inside SQLite3. This database contains a table called "abc<ALT+225>" (it is "abc" + symbol with the code 225 - greek letter "beta or a German symbol for "ss").
in what encoding? in ISO 8859-1, -15, beta aka sharp S is code 223 (U+00DF), not 225. in UTF-8, its C3,9F.
... Both the database and the table are created with default encoding.
what encodings are default on your system ? `\l+` in psql should show the encodings.
-- john r pierce, recycling bits in santa cruz -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general