Re: How to get the MySQL Command-Line Tool to display Unicode properly?

2018-03-20 Thread Roger House
On 03/15/2018 02:06 PM, Roger House wrote: On 03/15/2018 11:30 AM, shawn l.green wrote: Hi Roger, (please note, this is a bottom-post forum) On 3/13/2018 7:54 PM, Roger House wrote: > > On 03/13/2018 03:11 PM, Reindl Harald wrote: >> >> >> Am 13.03.2018 um 2

Re: How to get the MySQL Command-Line Tool to display Unicode properly?

2018-03-15 Thread Roger House
On 03/15/2018 11:30 AM, shawn l.green wrote: Hi Roger, (please note, this is a bottom-post forum) On 3/13/2018 7:54 PM, Roger House wrote: > > On 03/13/2018 03:11 PM, Reindl Harald wrote: >> >> >> Am 13.03.2018 um 22:59 schrieb Roger House: >>> In all r

Re: How to get the MySQL Command-Line Tool to display Unicode properly?

2018-03-13 Thread Roger House
.  It is only when I am running mysql and I issue a SELECT command to see what is in a row.  Then the UTF-8 is not rendered properly.  I believe the problem is with mysql. Roger On 03/13/2018 03:11 PM, Reindl Harald wrote: Am 13.03.2018 um 22:59 schrieb Roger House: In all respects except one

How to get the MySQL Command-Line Tool to display Unicode properly?

2018-03-13 Thread Roger House
Five months ago I posted the query shown below on StackOverflow.  I got one reply which was not of much help.  So I am trying again, hoping a more MySQL-centric forum might be able to solve my problem. Roger House How to get the MySQL Command-Line Tool to display Unicode properly? I use

How to get the MySQL Command-Line Tool to display Unicode properly

2017-10-18 Thread Roger House
I use a Python program to write text containing Unicode characters to a MySQL database.  As an example, two of the characters are     u'\u2640' a symbol for Venus or female     u'\u2642' a symbol for Mars or male I use utf8mb4 for virtually all character sets involved with MySQL.  Here is an