SQL dump should be in UTF-8, in order to support accented characters
A complete tool for creating and managing MSAccess databases.
Brought to you by:
marcieldeg
Menu
▾
▴
#104 SQL dump should be in UTF-8, in order to support accented characters
Summary: Dumping a database to SQL (any dialect) saves the file in Win-1252 encoding (at least on my Windows 10 machine). This means that if there are text values with accented characters and the SQL file gets imported into SQLite, the values become binary blobs...
Application version: 2.5.2.771
Steps to reproduce: Make sure that the database has some accented characters, for ex. "åøæ". Select Database->Tools->Dump and then SQLite, with values. Then import the SQL file into a fresh SQLite database
Expected results: The text values with accented characters should be in the database.
Actual results: The text values become binary blobs.
Discussion
Anonymous
Fixed in release 2.5.3.
Please check "UTF8" option in "Dump Options" window.