Textpad detect and opens sql file as UTF-8 when it is ANSI

General questions about using TextPad

Moderators: AmigoJack, bbadmin, helios, Bob Hansen, MudGuard

Post Reply
jpinto0
Posts: 4
Joined: Fri Jun 29, 2012 8:54 am

Textpad detect and opens sql file as UTF-8 when it is ANSI

Post by jpinto0 »

I have a particular SQL file that is encoded in ANSI (Windows 1252 code page) and displays correctly when viewed with Notepad, for example.
However, when I open the file with Textpad, it (wrongly) detects it as a UTF-8 file and saves it as such.
When I choose "Save As" and specifically select "Encoding" as ANSI, it displays a warning stating that file contains characters that cannot be converted to ANSI and asks me if I want to continue. Obvisouly, the 8 bit characters present in file are lost after this.
This is the only SQL file I have this problem with, all others work fine.
No matter what I have tried, Textpad always converts this file to UTF-8 on open. Document classes are configured correctly, I have checked that.
What can be the problem?

Thanks
jpinto0
Posts: 4
Joined: Fri Jun 29, 2012 8:54 am

File encoding detection when opening from windows explorer

Post by jpinto0 »

Correction: this happens for other files as well, also for text (.txt) files, not for SQL files only.
Also found this post that matches my problem:

http://forums.textpad.com/viewtopic.php?t=12926

Confirm that starting Textpad and do File -> Open, the file opens fine, double click on it from Windows Explorer don't.
Please help!
User avatar
bbadmin
Site Admin
Posts: 1020
Joined: Mon Feb 17, 2003 8:54 pm
Contact:

Post by bbadmin »

The file opening behaviour is inconsistent here, so we will rectify that is a future release.
Post Reply