MySQL Bugs: #70259: Encoding cyrillic characters when insert to db via Mysql for excel

Bug #70259	Encoding cyrillic characters when insert to db via Mysql for excel
Submitted:	6 Sep 2013 11:15	Modified:	18 Jan 2014 19:18
Reporter:	Maxim Kurchinskyj	Email Updates:
Status:	Not a Bug	Impact on me:	None
Category:	MySQL for Windows: MySQL for Excel	Severity:	S3 (Non-critical)
Version:	5.6.13	OS:	Windows
Assigned to:	Javier Treviño	CPU Architecture:	Any
Tags:	character, cyrillic, encoding, insert

Description:
When I try to APPEND data which containing cyrillic characters,via MySQL for Excel, in my mysql inserted questions marks instead cyrillic characters.

How to repeat:
always

Hi, can you please supply the SQL script to recreate your database along with some of the data (including the exact character set used with it??

Thanks.

Please provide what asked before. Thanks.

Tested inserting Cyrillic characters using MySQL for Excel, the data was inserted correctly in Cyrillic (verified it reading it in MySQL Workbench) and read back to Excel through an Insert Data operation correctly.

This does not seem to be a valid bug.
The user can reopen the bug if he can provide a configuration to reproduce the problem consistently.

The behavior the user reports may be caused by a misuse of misconfiguration, by misuse I mean attempting to append data with Cyrillic characters into a table configured with a character set (collation) that will not accept Cyrillic characters (e.g. latin1); by misconfiguration I mean attempting to insert Cyrillic characters into a table that has a correct character set (collation) like koi8r or utf8, but the server's character set variables are set to use a character set non suitable for Cyrillic characters.

Problem was in ODBC driver, where need setting charset