Set Database Character Set MysqLalter Database Da_NAME DEFAULT Character Set 'Charset'
Server Characterset: Latin1_Swedish_ci changed to Server CharactersEt: GB2312 When creating a database, use Create Database `MyDatabase` Default Character Set GB2312 Collate GB2312_CHINESE_CI
Show variables like 'char%';
In My.ini plus two sentences: [mysqld] default-character-set = GBK [client] default-character-set = GBK Remember to restart the database
The problem is temporarily resolved, and the set character_set_client = GB2312 is used when handling Chinese words.
Server characterset: latin1_swedish_ci into Server characterset: gb2312 when creating a database using CREATE DATABASE `mydatabase` DEFAULT CHARACTER SET gb2312 COLLATE gb2312_chinese_ci; SET character_set_connection = gb2312; SET character_set_results = gb2312; this way you can, but when each restart, but also Reset, is there any way to solve it?
MyConnection.connectionstring = "PERSIST security info = false; database = mydb; server = myhost; connect timeout = 30; user id = myuse; pwd = mypass; charSet = latin1
