From: | Igor Korot <ikorot01(at)gmail(dot)com> |
---|---|
To: | John R Pierce <pierce(at)hogranch(dot)com> |
Cc: | pgsql-general <pgsql-general(at)postgresql(dot)org> |
Subject: | Re: Invalid byte sequence for encoding UTF-8 0xc3\n |
Date: | 2017-07-30 20:43:42 |
Message-ID: | CA+FnnTyiJHc5SP8ygYy3Sv3nGrZugfAjJtU0Gx=7s0aDA1bnFw@mail.gmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
Hi, John,
On Sun, Jul 30, 2017 at 4:34 PM, John R Pierce <pierce(at)hogranch(dot)com> wrote:
> 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.
Is this "backslash + pipe + plus-sign"?
Trying it gives: "Invalid command".
Thank you.
>
>
> --
> john r pierce, recycling bits in santa cruz
>
>
>
> --
> Sent via pgsql-general mailing list (pgsql-general(at)postgresql(dot)org)
> To make changes to your subscription:
> http://www.postgresql.org/mailpref/pgsql-general
From | Date | Subject | |
---|---|---|---|
Next Message | John R Pierce | 2017-07-30 20:53:54 | Re: Invalid byte sequence for encoding UTF-8 0xc3\n |
Previous Message | John R Pierce | 2017-07-30 20:34:48 | Re: Invalid byte sequence for encoding UTF-8 0xc3\n |