Windows and character sets

from the Artful MySQL Tips List

In the US, the default code page is 437; in Europe, 850.

Wndows NotePad saves in ANSI format by default. It can be forced to save UTF-8 but the file will include a BOM which will prevent the file executing as a batch file.

The Windows CMD window gives very limited Unicode support. Most commands use ANSI. Only DIR, FOR /F and TYPE support Unicode. CMD only supports two character encodings with CMD /A and CMD /U. See for details.

PowerShell offers better but incomplete Unicode support.

A promising alternative to the severely limited Windows commandline client program is Tabby (formerly Terminus), a richly configurable terminal emulator, SSH/serial/Telnet client for Windows, macOS and Linux, see

Last updated 29 Jan 2022

Return to the Artful MySQL Tips page