Roland Walker
Roland Walker
You might want to take a look at the `python3 -c` output but using your actual DSN instead of the example we are using. Our example works for both of...
Hi! Encodings are tricky, but what's clear here is that the id value in question is being rendered as UTF-8 text. You should be able to simplify and narrow things...
Informative. Sadly, I am not able to reproduce. But your results with the literal convince me that mycli is at least part of the problem.
@pasenor while it is possible to automatically detect the encoding of file contents, that is only true with some limitations. I'd also say it is out-of-scope for mycli, and that...
Hi! Currently the best way is to set ``` [client] default-character-set = utf8mb4 ``` in `~/.my.cnf`. But in #915, @seamile is also working on a `--charset` CLI option to change...
Hi! That's very interesting! But I cannot duplicate the issue: ``` $ mycli --host localhost --port 3306 --user root Password: mysql root@localhost:(none)> SELECT DISTINCT CONCAT('User: ''',user,'''@''',host,''';') AS query FROM mysql.user;...
@pasenor excellent point.
Wait, how would that work? We set the charset before we make the connection.
Isn't it sufficient now to set `prompt_continuation = ''` in `~/.myclirc` ?
The newlines may still be there, in which case you might want to try following the query with `\clip` to copy it directly to the clipboard.