Snippets

1) Where are snippets stored?
2) Some of my snippets disappeared when I changed version (tried a daily snap), just bug or are they gone?

1) C:\Documents and settings\All Users\Application data\HeidiSQL\Snippets

2) Never saw that issue yet. Please check if some are existant in the above mentioned directory and still not displayed. If there are some, please tell us the filenames so I can fix something - thanks!

There are 7 files in that directory, 3 of which does not work. All are valid queries though. Can't see why they arn't working. Just downloaded the latest snap to see if that was better, but no change.

Adresslista.sql
Kundinfo.sql
Life Lista.sql

Adresslista.sql[code:1:6de8ef49ef]USE contact_se;
SELECT
webuserid as Kundnummer,
first_name as F

Can't reproduce that here. It's unlikely that this issue has something to do with the file contents, as you say they are not listed in the snippet menu, correct? Maybe the files are corrupted somehow?

Oh, missunderstanding then. They are listed, but when I click on one item, nothing happens - as if it knew the file was there but not being able to read its content... which reminds me to check permissions.... *checks* Nope, no difference.

Both files are written in codepage 1252 (ANSI - Latin I).

Edit:
Same problem occur when using the "Load .SQL-File" button.

Found the problem. Heidi won't read .sql files with odd characters in it, such as

Ah makes sense, yes. SQL files are opened by doing some load-with-UTF8-encoding-in-mind logic since we have switched to the unicode enabled SynEdit component (the editor itself). I'll check that asap and try to fix that.

Thanks a lot for keeping your good eyes on that issue!