|
Only two of the utf8_ collation types work with Columnstore.
- utf8_general_ci
- utf8_bin
All others result in NULL for Chinese characters.
CREATE DATABASE IF NOT EXISTS test;
|
|
DROP TABLE IF EXISTS test.chinesecs;
|
|
CREATE TABLE test.chinesecs (english_name VARCHAR(50), chinese_name VARCHAR(50)) DEFAULT CHARACTER SET utf8 COLLATE utf8_nopad_bin ENGINE=columnstore;
|
|
LOAD DATA LOCAL INFILE '~/Downloads/MOCK_DATA.csv' INTO TABLE test.chinesecs FIELDS TERMINATED BY ',' LINES TERMINATED BY '\n' IGNORE 1 LINES;
|
|
SELECT * FROM test.chinesecs ORDER BY chinese_name LIMIT 100;
|
|
MOCK_DATA.csv