Ads were blocked - no problem. But keep in mind that developing HeidiSQL, user support and hosting takes time and money. You may want to send a donation instead.

Importing csv/text file containing german characters

chandrasen's profile image chandrasen posted 2 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 2 years ago Permalink

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

chandrasen's profile image chandrasen posted 2 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 2 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.