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 files

usmeireles's profile image usmeireles posted 2 weeks ago in General Permalink

Hi, does anyone know why I always get an interrogation mark before the first row of my imported file? For example, ?ATIVO or ?DATA. Thanks!

ansgar's profile image ansgar posted 2 weeks ago Permalink

Perhaps because your file had a utf8 bom at the very beginning?

usmeireles's profile image usmeireles posted 2 weeks ago Permalink

Ansgar, thanks for your answer. Would you know what I have to do to solve it?

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.
ansgar's profile image ansgar posted 2 weeks ago Permalink

You can use Notepad++ to load that file and see if it has a BOM:

Description

Generally, many programs including HeidiSQL do not support BOM files, so I recommend converting your file to UTF-8 (without BOM)

usmeireles's profile image usmeireles posted 1 week ago Permalink

Hi, Ansgar! Only today I maanaged to put the hint into practice and it worked. Thank you!

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.