这是indexloc提供的服务,不要输入任何密码
Skip to content

It is not possible to import csv data to tables having columns with german umlauts in their names (RM #7156) #4884

@dpage

Description

@dpage

Issue migrated from Redmine: https://redmine.postgresql.org/issues/7156
Originally created by ED H at 2022-02-03 18:24:20 UTC.

It is not possible to use the import/export - function provided by pgadmin4 6.4 to import csv data to tables having columns with german umlauts in the column's names.
The error occurs even if the import file is empty, i.e. the error occurs independently of the imported data.

If you create a table like this described by the following create script then importing data leads to this error under WINDOWS 10 (see also attached screenshot):
'ERROR: invalid byte sequence for encoding "UTF8": 0xfc'

CREATE SCRIPT:

CREATE TABLE IF NOT EXISTS public."TableWithUmlautInColumnName"
(
"Hülsenfrüchte" text COLLATE pg_catalog."default"
)

TABLESPACE pg_default;

ALTER TABLE IF EXISTS public."TableWithUmlautInColumnName"
OWNER to postgres;

Metadata

Metadata

Type

No type

Projects

No projects

Milestone

Relationships

None yet

Development

No branches or pull requests

Issue actions