Search Postgresql Archives

Re: Invalid byte sequence for encoding UTF-8 0xc3\n

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



Hi, John,

On Sun, Jul 30, 2017 at 4:34 PM, John R Pierce <pierce@xxxxxxxxxxxx> 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@xxxxxxxxxxxxxx)
> To make changes to your subscription:
> http://www.postgresql.org/mailpref/pgsql-general


-- 
Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general



[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
[Index of Archives]     [Postgresql Jobs]     [Postgresql Admin]     [Postgresql Performance]     [Linux Clusters]     [PHP Home]     [PHP on Windows]     [Kernel Newbies]     [PHP Classes]     [PHP Books]     [PHP Databases]     [Postgresql & PHP]     [Yosemite]

  Powered by Linux