--binary-mode
This page is part of MariaDB's Documentation.
The parent of this page is: mariadb & mysql for MariaDB Enterprise Server
Topics on this page:
Overview
This is a command-line option for the mariadb & mysql commands.
Binary mode allows certain character sequences to be processed as data that would otherwise be treated with a special meaning by the parser. Specifically, this switch turns off parsing of all client commands except \C and DELIMITER in non-interactive mode (i.e., when binary mode is combined with either 1) piped input, 2) the --batch mysql option, or 3) the 'source' command). Also, in binary mode, occurrences of '\r\n' and ASCII '\0' are preserved within strings, whereas by default, '\r\n' is translated to '\n' and '\0' is disallowed in user input.