Currently Datical supports the encodings listed in the Supported Encodings section of this page. This article includes instructions to help identify special characters in a sql script.
...
There are also a variety of programmatic methods for removing special characters. For example, you can use git bash to remove special characters with the tr command (from https://alvinalexander.com/blog/post/linux-unix/how-remove-non-printable-ascii-characters-file-unix/).
Please note, you may need to manipulate the command below if you wish to keep certain special characters as this will strip out ALL special characters. It would need to be used with caution:
| Code Block |
|---|
tr -cd '\11\12\15\40-\176' < file-with-binary-chars > clean-file |