MySQL Forums
Forum List  »  MySQL for Excel

Re: Japanese and SSH remote connection problems
Posted by: Javier Treviño
Date: June 09, 2017 03:57PM

Hi Phuong Phan,
As for the SSH connection you are trying to establish, MySQL for Excel does not support opening a SSH tunnel on-the-fly as MySQL Workbench does, but you can trick this by creating the SSH tunnel yourself and create a connection to the tunnel.
Read this blog post about it:
https://blogs.oracle.com/mysql/guide-to-create-a-tunneled-ssh-connection-in-mysql-for-excel

Now about the Japanese characters, I performed a quick test and can create a table with Japanese characters using a charset of utf8_general_ci through an Export Data operation, and then I am able to do an Edit Data on that created table and add more rows with Japanese text and commit the changes. If I check the data in MySQL Workbench I see it correctly in Japanese. So I am not sure what is happening at your end.

Can you please check in MySQL Workbench the value of all the "character_set" variables (there are 8) and post them here? You can check them by going to "Status and System Variables" at the Management section in the left pane of a SQL Editor, and then go the "System Variables" tab within the Server Variables window, and filter by All.

Best regards.

====================================
Javier Treviño
MySQL on Windows Team

Options: ReplyQuote


Subject
Views
Written By
Posted
Re: Japanese and SSH remote connection problems
737
June 09, 2017 03:57PM


Sorry, you can't reply to this topic. It has been closed.

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.