Importing files

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

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

usmeireles's profile image usmeireles posted 4 years ago Permalink

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

ansgar's profile image ansgar posted 4 years 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 4 years 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.