|
Replies:
0
-
Pages:
1
|
|
|
Posts:
1
Registered:
6/30/11
|
|
|
|
cannot connect to server with utf8mb4 character set
Posted:
Jul 1, 2011 7:27 AM
|
|
|
Hi everyone.
I see in the Toad for MySQL Beta 6 release notes that MySQL 5.5 is not officially supported, but has anyone been able to get Toad to connect to MySQL 5.5.13 when the server is configured for both character set utf8mb4 and skip character set client handshake?
Every time I try to connect, I get the following error:
Exception: System.Collections.Generic.KeyNotFoundException
Message : The given key was not present in the dictionary.
Stack Trace:
at System.ThrowHelper.ThrowKeyNotFoundException()
at System.Collections.Generic.Dictionary`2.get_Item(TKey key)
at MySql.Data.MySqlClient.CharSetMap.GetCharacterSet(DBVersion version, String CharSetName)
at MySql.Data.MySqlClient.CharSetMap.GetEncoding(DBVersion version, String CharSetName)
at MySql.Data.MySqlClient.Driver.Configure(MySqlConnection connection)
at MySql.Data.MySqlClient.MySqlConnection.Open()
at Quest.Toad.MySQL.MySQLConnection.DoBeforeConnect()
at Quest.Toad.Db.Connection.Connect(Boolean notify)
at Quest.Toad.Db.Provider.BackgroundConnector.CreateBackgroundConnection()
If I change the character set in my.ini to utf8 and restart the MySQL server, then all is fine and I can connect with Toad for MySQL Beta 6.
Many thanks,
Mike
|
|
|
|
Legend
|
|
Guru: 2001
+
pts
|
|
Expert: 751
- 2000
pts
|
|
Enthusiast: 31
- 750
pts
|
|
Novice: 0
- 30
pts
|
|
Moderators
|
|
Helpful answer
(5 pts)
|
|
Answered
(10 pts)
|
|
