distal-attribute
distal-attribute
distal-attribute
distal-attribute

UTF8 file not detected (read as ANSI)

User, date Message
Written by kelyeMoney, Euro
4 years ago
Category: Import/Export
5 posts since Fri, 18 Jun 10
Hello, i have an 8mb sql file that contains utf8 data but only after half.

According to this release HeidiSQL reads only the first 100k to determine if it's a (BOM-less) utf8 file.

Is there a way to force HeidiSQL to treat all files as UF8 ? or per import file?

Thanks!
Written by ansgar
4 years ago
5045 posts since Fri, 07 Apr 06
No, not currently. Files are only auto detected.
Written by kelyeMoney, Euro
4 years ago
5 posts since Fri, 18 Jun 10
so the only solution would be to insert an UTF8 char at the beginning of the file ...
Written by ansgar
4 years ago
5045 posts since Fri, 07 Apr 06
YessmileThe issue request #2025 is surely legitime.
Written by ansgar
4 years ago
5045 posts since Fri, 07 Apr 06
Encoding is now selectable when you open a SQL file.
 

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