Importing csv/text file containing german characters

[expired user #10922]'s profile image [expired user #10922] posted 7 years ago in Import/Export Permalink

I am facing a problem while importing the csv/text file (which has german characters) to the table in PostgreSQL database, using HeidiSQL.

For example "Dr. Höppner" is being imported as "Dr. Höppner".

I have tried converting my excel file to csv and also text with UTF-8 encoding. Even this seems to be not working.

It would be great if anybody helps me in solving this problem.

kalvaro's profile image kalvaro posted 7 years ago Permalink

You are either not using PostgreSQL or not using HeidiSQL :-?

[expired user #10922]'s profile image [expired user #10922] posted 7 years ago Permalink

@kalvaro Thank you for the reply. Just to confirm I am using postgreSQL and HeidiSQL. It would be great if you can help me out on how can I import an excel file which contains german characters (say: äöüß) to postgreSQL database as it is.

kalvaro's profile image kalvaro posted 7 years ago Permalink

Oops... I hadn't realised that HeidiSQL actually has experimental support for PostgreSQL. My excuses!

(Unfortunately, I know nothing about such DBMS so I can't be of much help.)

Please login to leave a reply, or register at first.