Bug #12452 Don't save advanced parameters
Submitted: 9 Aug 2005 6:18 Modified: 18 Jun 2006 21:36
Reporter: Misha Kryukov Email Updates:
Status: No Feedback Impact on me:
None 
Category:MySQL Query Browser Severity:S2 (Serious)
Version:1.1.13 OS:Windows (Windows 2000)
Assigned to: CPU Architecture:Any

[9 Aug 2005 6:18] Misha Kryukov
Description:
I add advanced parameters to mysqlx_user_connections.xml at 
(C:\Documents and Settings\UserName\Application Data\MySQL)
Such as useUnicode=true and characterEncoding=Cp1251
for russian encoding
After I run Query Browser it removes advanced parameters
or makes copy of the connection without these parameters
 Look at this XML

<?xml version="1.0"?>
<user_connections>
  <last_connection>1</last_connection>
  <password_storage_type>1</password_storage_type>
  <user_connection>
    <connection_name>Test</connection_name>
    <username>me</username>
    <hostname>192.168.0.1</hostname>
    <port>3306</port>
    <schema>test</schema>
    <advanced_options>
      <advanced_option>useUnicode=true</advanced_option>
      <advanced_option>characterEncoding=Cp1251</advanced_option>
    </advanced_options>
    <storage_path></storage_path>
    <notes></notes>
    <connection_type>0</connection_type>
    <storage_type>1</storage_type>
    <password/>
  </user_connection>
  <user_connection>
    <connection_name>Test</connection_name>
    <username>me</username>
    <hostname>192.168.0.5</hostname>
    <port>3306</port>
    <schema>test</schema>
    <advanced_options/>
    <storage_path></storage_path>
    <notes></notes>
    <connection_type>0</connection_type>
    <storage_type>1</storage_type>
    <password/>
  </user_connection>
</user_connections>

How to repeat:
Make new connection Tools > Manage Connections
Then close application and edit configuration file:
C:\Documents and Settings\UserName\Application Data\MySQL\mysqlx_user_connections.xml 
Instead:
    <advanced_options/>
Write:
   <advanced_options>
      <advanced_option>useUnicode=true</advanced_option>
      <advanced_option>characterEncoding=Cp1251</advanced_option>
   </advanced_options>
Start application. You can see these options from gui interface of connection
dialog. Connect to the server (Main window appears). 
Then Tools > Manage Connections again.
Now you can see two connections with the same name.
The used connection at this time without advanced parameters.
You can edit it manually also but application will change it to:
     <advanced_options/>
next time you use this connection.

Suggested fix:
Russians relax and go... may be to get "yet another sql db and client" 
:(
Actualy, I have no idea. I'm just mysql user.
[9 Aug 2005 6:27] Misha Kryukov
Why I need useUnicode=true and characterEncoding=Cp1251 ???
Because I connect to mysql database at linux with default latin1
[10 Aug 2005 15:45] Aleksey Kishkin
Misha, useUnicode=true and characterEncoding=Cp1251 are parameters for connections in the  connector/j (jdbc driver). But query browser and mysql administrator does not use java and jdbc driver for connections. 

Could you please point me a place in the documentation where described using of that parameters in the mysql query browser?
[10 Sep 2005 23:00] Bugs System
No feedback was provided for this bug for over a month, so it is
being suspended automatically. If you are able to provide the
information that was originally requested, please do so and change
the status of the bug back to "Open".
[18 May 2006 21:36] Valeriy Kravchuk
Please, check with a newer version of QB, 1.1.20, and inform about the results.
[13 Jun 2006 12:34] Administrator Biovitrum
Yep, bug still here
[18 Jun 2006 23:00] Bugs System
No feedback was provided for this bug for over a month, so it is
being suspended automatically. If you are able to provide the
information that was originally requested, please do so and change
the status of the bug back to "Open".