FAQ Series | How to use the UTF8 character set under Infobright

At present, there are more and more infobright applications, some scenarios need to be shared with the station management system, so it is necessary to have both BrightHouse and MyISAM two kinds of engines.
At this point, if you need the BrightHouse engine to support the UTF8 character set, you need:
1. Database objects must be created using the UTF8 character set, which is particularly critical, otherwise it is not supported UTF8;
2. The UTF8 character set is also used when creating data table objects;
3. import files are converted to the UTF8 character set in advance;
4. When connecting Infobright, execute set names UTF8;
5. Import the file to see if the character set is correct;

In another scenario, the MyISAM table may also need to support UTF8, which is relatively troublesome:
1. Database object creation does not matter, do not force must be utf8;
2. Be sure to use the UTF8 character set when creating data table objects;
3. Convert all import files into the UTF8 character set insert syntax, write data directly, Infobright does not support load data infile way to import UTF8 character set files;
4. You can also import other non-character fields and update them with update;

--------------------------------------Split Line--------------------------------------

http://zhishuedu.comTraining is a professional quality training brand jointly launched by senior MySQL expert Ye Jinlong and Wu Bingxi, with MySQL dba combat optimization and Python devops Development course, which is the most conscientious and The most quality training courses.

This article is from the "Lao Ye teahouse" blog, please be sure to keep this source http://imysql.blog.51cto.com/1540006/1879751

FAQ Series | How to use the UTF8 character set under Infobright