Re: ucs-2 server - yes. usc-2 client - no. What the ....?

[Mike Lischke]

Randy wrote:

> Mike, you pointed that mysql does support UCS-2.
> Right, but the whole point of my post was the
> bummer that if I have an application that uses
> UCS-2 as its character set, I cannot connect to
> mysql as a UCS-2 client and send/receive string
> data encoded as UCS-2. I'll have to encode/decode
> to/from UTF-8. That's heavy price to pay, and... I
> must conclude that the jdbc driver does the same
> since java is natively a UTF-16 app.

Well, the other price would be to allow all kind of charsets for the connection, which means a lot of conversion code in the application. I think the lesser evil is to stay with a flexible and universal connection charset and let the app convert what it needs. A clear interface is often much more worth than saving a few CPU cycles.

Mike

Mike Lischke, MySQL Developer Tools
Oracle Corporation

MySQL Workbench on Github: https://github.com/mysql/mysql-workbench
On Twitter: https://twitter.com/MySQLWorkbench
On Slack: mysqlcommunity.slack.com (#workbench)
Report bugs to http://bugs.mysql.com
MySQL documentation can be found here: http://dev.mysql.com/doc/refman/8.0/en/