Details
-
Bug
-
Status: Closed (View Workflow)
-
Major
-
Resolution: Won't Do
-
1.5.3
-
None
Description
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; |
Attachments
Issue Links
- relates to
-
MCOL-4103 Columnstore LDI doesn't support charsets, particularly utf8mb4
-
- Closed
-