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");
EOF

test\tplease

And

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

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

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


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


Sorry, only registered users may post in this forum.

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.