MySQL Forums
Forum List  »  General

mysql output converting char(9) to '\t' (5c 74)
Posted by: Bryan Lenihan
Date: January 22, 2021 05:20PM

When I run mysql command line in Ubuntu, char(9) TAB is rednering \t in the output. The \t is not 009 but 5c 74.

Here are the examples:
$ mysql --defaults-file=my.cnf --silent << EOF
SELECT CONCAT("test", CHAR(9), "please");



$ mysql --defaults-file=my.cnf --silent << EOF | hd
SELECT CONCAT("test", CHAR(9), "please");

00000000 74 65 73 74 5c 74 70 6c 65 61 73 65 0a |test\tplease.|

What can I do to get the output to render 009. Is this the MySql client or Ubuntu?

Thanks for your assistance.
Bryan M Lenihan

Options: ReplyQuote

Written By
mysql output converting char(9) to '\t' (5c 74)
January 22, 2021 05:20PM

Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.