I have a CSV file encoded Unicode UTF-8.
Here is my table schema:
This imports all the data but it is not showing Unicode in the data.Code:CREATE TABLE `country_states` ( `country_name` VARCHAR(50) NULL DEFAULT NULL COLLATE 'utf8_unicode_ci', `country_iso_char_2_code` VARCHAR(50) NULL DEFAULT NULL COLLATE 'utf8_unicode_ci', `state_code` VARCHAR(50) NULL DEFAULT NULL COLLATE 'utf8_unicode_ci', `state_name` VARCHAR(50) NULL DEFAULT NULL COLLATE 'utf8_unicode_ci' ) CHARSET=UTF8 COLLATE='utf8_unicode_ci' ENGINE=MyISAM ROW_FORMAT=DEFAULT
What am I doing wrong?Code:LOAD DATA LOCAL INFILE '/downloads/cdh_download.csv' INTO TABLE country_states FIELDS TERMINATED BY ',' OPTIONALLY ENCLOSED BY '"' LINES TERMINATED BY '\r\n' IGNORE 1 LINES;



Reply With Quote
Bookmarks