Don’t use SQL_ASCII Why not? While the name suggests that this encoding is in some meaningful way related to ASCII, it is not. Instead, it simply forbids the use of NUL bytes. More importantly, SQL_ASCII means “no conversions” for the purpose of all encoding conversion functions.