Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- static String url = "jdbc:mysql://localhost:3306/stage?verifyServerCertificate=false&characterEncoding=UTF8";
- final String sql2 = ("LOAD DATA INFILE" + filetoEat +
- "INTO TABLE staging." +tableName +
- "CHARACTER SET UTF8
- FIELDS TERMINATED BY',' ENCLOSED BY '"'
- LINES TERMINATED BY 'n' IGNORE 1 LINES");
- CREATE TABLE `zmi064_02` (
- `Material` varchar(11) CHARACTER SET utf8 DEFAULT NULL,
- `Material Description` varchar(60) CHARACTER SET utf8 DEFAULT NULL,
- `MatType` text CHARACTER SET utf8,
- `MatGrp` text CHARACTER SET utf8,
- `ClassType` text CHARACTER SET utf8,
- `Class type Text` text CHARACTER SET utf8,
- `Class` text CHARACTER SET utf8,
- `Class Text` text CHARACTER SET utf8,
- `CharactName` text CHARACTER SET utf8,
- `CharactValue` text CHARACTER SET utf8,
- `Plant` varchar(6) CHARACTER SET utf8 DEFAULT NULL
- ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
- character_set_client utf8
- character_set_connection utf8
- character_set_database utf8
- character_set_filesystem binary
- character_set_results utf8
- character_set_server utf8
- character_set_system utf8
- collation_connection utf8_general_ci
- collation_database utf8_unicode_ci
- collation_server utf8_general_ci
- Invalid utf8 character string: 'LUG'
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement