Re: Is this bug in MySQL Server 5.7.14?
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.
Subject
Views
Written By
Posted
2962
March 26, 2017 07:41AM
1197
March 26, 2017 10:43AM
1399
March 26, 2017 11:33AM
Re: Is this bug in MySQL Server 5.7.14?
1263
March 26, 2017 12:11PM
1179
March 26, 2017 12:24PM
1111
March 26, 2017 02:34PM
1189
March 27, 2017 04:50AM
1167
March 27, 2017 10:56AM
1191
March 27, 2017 12:33PM
1723
March 27, 2017 02:55PM
1160
March 27, 2017 03:03PM
1088
March 27, 2017 03:32PM
1251
March 27, 2017 10:10PM
1060
March 27, 2017 10:17PM
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.