This file is in GBK charset, don't open it in utf8/unicode mode.

1. table creation:

CREATE TABLE `test_gbk` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `c1` varchar(20) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=gbk;

2. odbc connection string:

Provider=MSDASQL.1;Password=*****;Persist Security Info=True;User ID=*****;Extended Properties="DRIVER={MySQL ODBC 5.3 Driver};SERVER=127.0.0.1;DATABASE=test;UID=*****;PWD=*****;OPTION=2058;CHARSET=gbk;BIG_PACKETS=1;COMPRESSED_PROTO=1;NO_PROMPT=1;MULTI_STATEMENTS=1"

3. sql commands in GBK charset

insert into test_gbk set c1="ª¡";

update aa set c1="ª¡" where id=1;