pg.ddx.io  pgsql-bugs@postgresql.org mailing list archive  
help / color / mirror / Atom feed
From: Wilm Hoyer <W.Hoyer@dental-vision.de>
To: Aetimpani Yeatina <aetimpani@yandex.com>
To: pgsql-bugs@lists.postgresql.org <pgsql-bugs@lists.postgresql.org>
Subject: AW: Stranger Character Input Bug
Date: Wed, 24 Jun 2020 07:00:07 +0000
Message-ID: <54f6dca53f0d43ebb4c14c1ce77ce37a@dental-vision.de> (raw)
In-Reply-To: <58531592920530@mail.yandex.com>
References: <58531592920530@mail.yandex.com>

> Hi. I suppose found a bug. I have explained that on stackoverflow (Link: https://stackoverflow.com/questions/62535206/postgresql-doesnt-respond-when-i-input-stranger-charact... )
I think, this is a limitation oft he windows command shell, not a PostgreSQL bug (i'm not a PostgreSQL developer, so i might be wrong on that point)

You might give any of the following workarounds a try:
- Microsoft is currently working on "Windows Terminal" with full UTF-8 character support - you can download a beta of that software from Microsoft Store.
- Use a third Party Command Line Tool
- Use the PostgreSQL Unicode Escape Syntax for literals for your input values - see https://www.postgresql.org/docs/current/sql-syntax-lexical.html
      e.g. insert into jobs(id, name) values (10, E'a\uxxxxs\uxxxx') - you have to replace the xxxx with the unicode codepoint value of the character
- Use the "Linux on Windows Subsystem" Windows 10 feature - inside the Linux distribution you choose as your subsystem, you can use a shell with full unicode character set support for your commands

As a side note: IIRC the windows power shell suffers from the same limitations as the command line tool, so using that toll as workaround will not help with your problem.

Regards
Wilm.

Message-ID: <54f6dca53f0d43ebb4c14c1ce77ce37a@dental-vision.de>
Permalink:  ../54f6dca53f0d43ebb4c14c1ce77ce37a@dental-vision.de/
Also on:    postgresql.org/message-id/54f6dca53f0d43ebb4c14c1ce77ce37a@dental-vision.de

 · 

reply

Reply instructions:

You may reply publicly to this message via plain-text email
using any one of the following methods:

* Reply to all the recipients using the --to and --cc options:
  reply via email

  To: pgsql-bugs@postgresql.org
  Cc: W.Hoyer@dental-vision.de, aetimpani@yandex.com, pgsql-bugs@lists.postgresql.org
  Subject: Re: AW: Stranger Character Input Bug
  In-Reply-To: <54f6dca53f0d43ebb4c14c1ce77ce37a@dental-vision.de>

* Save the following mbox file, import it into your mail client,
  and reply-to-all from there: mbox

This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox