## Environment details

[umshastr@hod03]/export/umesh/server/binaries/GABuilds/mysql-advanced-5.7.18: locale
LANG=en_US.UTF-8
LC_CTYPE="en_US.UTF-8"
LC_NUMERIC="en_US.UTF-8"
LC_TIME="en_US.UTF-8"
LC_COLLATE="en_US.UTF-8"
LC_MONETARY="en_US.UTF-8"
LC_MESSAGES="en_US.UTF-8"
LC_PAPER="en_US.UTF-8"
LC_NAME="en_US.UTF-8"
LC_ADDRESS="en_US.UTF-8"
LC_TELEPHONE="en_US.UTF-8"
LC_MEASUREMENT="en_US.UTF-8"
LC_IDENTIFICATION="en_US.UTF-8"
LC_ALL=

 cat /etc/*release
Oracle Linux Server release 7.1
NAME="Oracle Linux Server"
VERSION="7.1"
ID="ol"
VERSION_ID="7.1"
PRETTY_NAME="Oracle Linux Server 7.1"
ANSI_COLOR="0;31"
CPE_NAME="cpe:/o:oracle:linux:7:1"
HOME_URL="https://linux.oracle.com/"
BUG_REPORT_URL="https://bugzilla.oracle.com/"

ORACLE_BUGZILLA_PRODUCT="Oracle Linux 7"
ORACLE_BUGZILLA_PRODUCT_VERSION=7.1
ORACLE_SUPPORT_PRODUCT="Oracle Linux"
ORACLE_SUPPORT_PRODUCT_VERSION=7.1
Red Hat Enterprise Linux Server release 7.1 (Maipo)
Oracle Linux Server release 7.1


## MySQL Start up commands etc
rm -rf 83950
bin/mysqld --initialize-insecure --basedir=$PWD --datadir=$PWD/83950 -v
bin/mysqld --no-defaults --basedir=$PWD --datadir=$PWD/83950 --core-file --socket=/tmp/mysql_ushastry.sock --port=3306 --log-error=$PWD/83950/log.err --secure-file-priv=/tmp/ 2>&1 &

## Sample load file

[umshastr@hod03]/export/umesh/server/binaries/GABuilds/mysql-advanced-5.7.18: echo "\ä" >/tmp/test.txt
[umshastr@hod03]/export/umesh/server/binaries/GABuilds/mysql-advanced-5.7.18: cat /tmp/test.txt
\ä

[umshastr@hod03]/export/umesh/server/binaries/GABuilds/mysql-advanced-5.7.18: bin/mysql -uroot -S /tmp/mysql_ushastry.sock
Welcome to the MySQL monitor.  Commands end with ; or \g.
Your MySQL connection id is 3
Server version: 5.7.18-enterprise-commercial-advanced MySQL Enterprise Server - Advanced Edition (Commercial)

Copyright (c) 2000, 2017, Oracle and/or its affiliates. All rights reserved.

Oracle is a registered trademark of Oracle Corporation and/or its
affiliates. Other names may be trademarks of their respective
owners.

Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.

root@localhost [(none)]> create database test;
Query OK, 1 row affected (0.00 sec)

root@localhost [(none)]> use test
Database changed
root@localhost [test]> CREATE TABLE t1 (a VARCHAR(10) CHARACTER SET utf8);
Query OK, 0 rows affected (0.00 sec)

root@localhost [test]> LOAD DATA INFILE '/tmp/test.txt' INTO TABLE t1 CHARACTER SET utf8;
ERROR 1300 (HY000): Invalid utf8 character string: ''
root@localhost [test]>
root@localhost [test]> select * from t1;
Empty set (0.00 sec)

root@localhost [test]> insert into t1 values('\ä');
Query OK, 1 row affected (0.00 sec)

root@localhost [test]> select * from t1;
+------+
| a    |
+------+
| ä    |
+------+
1 row in set (0.00 sec)

root@localhost [test]> -- build details
root@localhost [test]> \! cat docs/INFO_SRC
commit: c1df4fd3c54174ff13b1d5de10e2506e868b28b4
date: 2017-03-18 08:42:33 +0100
build-date: 2017-03-18 08:45:26 +0100
short: c1df4fd
branch: mysql-5.7.18-release

MySQL source 5.7.18

root@localhost [test]>