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

2018-03-21 Thread Johan De Meersman
03.2018 um 22:59 schrieb Roger House: >>> >>> In all respects except one, the treatment of Unicode works just >>> fine. >>> >>> I can write Unicode to database tables, read it, display it, >etc., >>> >>> with no problems.

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

2018-03-20 Thread Roger House
2:59 schrieb Roger House: >>> In all respects except one, the treatment of Unicode works just fine. >>> I can write Unicode to database tables, read it, display it, etc., >>> with no problems. The exception is mysql, the MySQL Command-Line >>> Tool. When I execute

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

2018-03-15 Thread Roger House
ects except one, the treatment of Unicode works just fine. >>> I can write Unicode to database tables, read it, display it, etc., >>> with no problems. The exception is mysql, the MySQL Command-Line >>> Tool. When I execute a SELECT statement to see rows in a table >>

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

2018-03-15 Thread shawn l.green
ust fine. >>> I can write Unicode to database tables, read it, display it, etc., >>> with no problems. The exception is mysql, the MySQL Command-Line >>> Tool. When I execute a SELECT statement to see rows in a table >>> containing the Venus and Mars Unicode ch

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

2018-03-13 Thread Roger House
treatment of Unicode works just fine. I can write Unicode to database tables, read it, display it, etc., with no problems. The exception is mysql, the MySQL Command-Line Tool. When I execute a SELECT statement to see rows in a table containing the Venus and Mars Unicode characters, here is what I

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

2018-03-13 Thread Reindl Harald
Am 13.03.2018 um 22:59 schrieb Roger House: In all respects except one, the treatment of Unicode works just fine. I can write Unicode to database tables, read it, display it, etc., with no problems. The exception is mysql, the MySQL Command-Line Tool. When I execute a SELECT statement to see

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 a

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

2017-10-19 Thread Hal.sz S.ndor
2017/10/18 18:32 ... Roger House: I get the same behavior with the MySQL Command Line Tool when I run it on Windows, Mac OS X, and Ubuntu, so I'm pretty sure the problem has to do with mysql itself. What do you know about the displays to which the client is writing? In the case of "

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

2017-10-18 Thread Roger House
n, all tables are created with these parameters:     ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci In all respects except one, the treatment of Unicode works just fine.  I can write Unicode to database tables, read it, display it, etc., with no problems.  The exception is mysq

Multiple sql lines in command line tool

2003-10-15 Thread Matt Young
I am running the command line in two modes. In one I pipe to it in an application with arguments -s -n -N -r; and I can send multiple queries in one write to the mysql command line too. I then run mysql command tool in the linux shell with the same parameters and I cannot submit multiple queri

RE: Problems with "ORDER BY" from C API (works from command-line tool mysql.exe)

2002-11-04 Thread Christer Holmström \(at Home\)
API (works from command-line tool mysql.exe) At 11:56 +0100 11/4/02, Joseph Bueno wrote: >Christer Holmström (at Home) wrote: > >> Hi! >> >> This SQL works perfect when running the command line tool mysql.exe >> >> SELECT exe, sum(duration) FROM data GROUP BY e

Re: Problems with "ORDER BY" from C API (works from command-line tool mysql.exe)

2002-11-04 Thread Paul DuBois
At 11:56 +0100 11/4/02, Joseph Bueno wrote: Christer Holmström (at Home) wrote: Hi! This SQL works perfect when running the command line tool mysql.exe SELECT exe, sum(duration) FROM data GROUP BY exe ORDER BY 2 BUT when running from the C API, the "ORDER BY" part doesn'

Re: Problems with "ORDER BY" from C API (works from command-line tool mysql.exe)

2002-11-04 Thread Benjamin Pflugmann
Hi. On Mon 2002-11-04 at 11:56:40 +0100, [EMAIL PROTECTED] wrote: > Christer Holmström (at Home) wrote: [...] > > This SQL works perfect when running the command line tool mysql.exe > > > > SELECT exe, sum(duration) FROM data GROUP BY exe ORDER BY 2 > > > > BUT

RE: Problems with "ORDER BY" from C API (works from command-line tool mysql.exe)

2002-11-04 Thread Christer Holmström \(at Home\)
k' Cc: 'Joseph Bueno'; [EMAIL PROTECTED] Subject: RE: Problems with "ORDER BY" from C API (works from command-line tool mysql.exe) The code works in that sence that I get resultsets, the only thing that does not work is the "ORDER BY" option for the SELECT statement. Th

RE: Problems with "ORDER BY" from C API (works from command-line tool mysql.exe)

2002-11-04 Thread Christer Holmström \(at Home\)
;; [EMAIL PROTECTED] Subject: Re: Problems with "ORDER BY" from C API (works from command-line tool mysql.exe) Then I would suggest you check your C code. The program 'mysql' uses the C API. Christer Holmström (at Home) wrote: >Hi, and thanks for the response, but unfortun

RE: Problems with "ORDER BY" from C API (works from command-line tool mysql.exe)

2002-11-04 Thread Christer Holmström \(at Home\)
- From: Joseph Bueno [mailto:joseph.bueno@;trader.com] Sent: den 4 november 2002 11:57 To: Christer Holmström (at Home) Cc: [EMAIL PROTECTED] Subject: Re: Problems with "ORDER BY" from C API (works from command-line tool mysql.exe) Christer Holmström (at Home) wrote: > Hi! >

Problems with "ORDER BY" from C API (works from command-line tool mysql.exe)

2002-11-04 Thread Christer Holmström \(at Home\)
Hi! This SQL works perfect when running the command line tool mysql.exe SELECT exe, sum(duration) FROM data GROUP BY exe ORDER BY 2 BUT when running from the C API, the "ORDER BY" part doesn't seem active, why? Please h

Re: Command Line Tool

2002-04-05 Thread BD
Lenny, You might find it easier to use a GUI like MySQL Front from http://www.anse.de/mysqlfront/. It will save you a great deal of time. Just enter (or copy and paste) the SQL into their query window and press a button. Editing your errors are also a lot easier. It is free or you can

Fw: Command Line Tool

2002-04-05 Thread Lenny Sorey
No problem Paul, I understood what you meant. Lenny Sorey - Original Message - From: "Paul DuBois" <[EMAIL PROTECTED]> To: "Lenny Sorey" <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]> Sent: Friday, April 05, 2002 11:17 AM Subject: Re: Command Line Tool

Re: Command Line Tool

2002-04-05 Thread Paul DuBois
At 10:43 -0600 4/5/02, Paul DuBois wrote: >At 10:29 -0600 4/5/02, Lenny Sorey wrote: >>I'm having a bit of a problem trying to get MySQL version 4.0.1-alpha-max-nt >>binary version >> >>to accept The Command - Line Tool to run a script to create a table. >>

Re: Command Line Tool

2002-04-05 Thread Paul DuBois
At 10:29 -0600 4/5/02, Lenny Sorey wrote: >I'm having a bit of a problem trying to get MySQL version 4.0.1-alpha-max-nt >binary version > >to accept The Command - Line Tool to run a script to create a table. > >My operating system is Windows 2000 Professional. I can conne

Command Line Tool

2002-04-05 Thread Lenny Sorey
I'm having a bit of a problem trying to get MySQL version 4.0.1-alpha-max-nt binary version to accept The Command - Line Tool to run a script to create a table. My operating system is Windows 2000 Professional. I can connect with MyODBC-3.51.02.exe without any problem and run successful qu

How to get my shell readline settings in mysql command line tool?

2001-06-11 Thread kevin1
Hello all, I use the bash shell and the vi editing mode (set -o vi) in my .inputrc. On one of my boxes, I managed to get the command line tool (mysql) to honour that setting. However, I have forgotten how I did that. Does anyone know how to do that