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.

UTF encoded data

Gaetano's profile image Gaetano posted 5 months ago in General Permalink

I was trying to upload a txt file (Unix UTFD encoded) to MariaDB and the UTF characters didn't display properly. Someone tried to use the data and displayed it on a web page with explicit tag defining the data as UTF and it displayed properly.

Example from the text file: Großhöflein

displays as follows in HeidiSQL data viewing tab: Großhöflein

The collation in the table is utf8mb64_general_ci

Is there a way to fix that display in the settings?

I have attached an extract of the source file that includes the above example (PS I tried to attach a zipped version but the file type was not accepted).

Cheers, Gaetano.

1 attachment(s):
ansgar's profile image ansgar posted 5 months ago Permalink

Your file looks like a normal utf8 file here. Perhaps you did not select the right encoding of the file when opening it in HeidiSQL. Be sure not to select "Auto-detect":

Description

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




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.