Re: Is this bug in MySQL Server 5.7.14?
Posted by: Peter Brawley
Date: March 26, 2017 12:11PM

I saved your sample line as a utf-8 text file to c:/tmp/in.txt, then ran the following in 5.6 and 5.7 both, and got the same correct result:

CREATE TABLE t.gk ( ben_text varchar(420) NOT NULL COMMENT '?????' ) 
ENGINE = MYISAM CHARACTER SET utf8 COLLATE utf8_general_ci; 

load data local infile 'c:/tmp/in.txt'
into table t.gk
fields terminated by ',' enclosed by '"' lines terminated by '\r\n' ;

select * from t.gk;
+---------------------------------------------+
| ben_text                                    |
+---------------------------------------------+
| "Coleção Roadster casaco/colete - 2016".    |
+---------------------------------------------+

If you're seeing '�', I'd say sumfin' in your chain ain't utf-8.

Options: ReplyQuote




Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.