Advertisement
Guest User

Untitled

a guest
Apr 21st, 2017
56
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 1.31 KB | None | 0 0
  1. static String url = "jdbc:mysql://localhost:3306/stage?verifyServerCertificate=false&characterEncoding=UTF8";
  2.  
  3. final String sql2 = ("LOAD DATA INFILE" + filetoEat +
  4. "INTO TABLE staging." +tableName +
  5. "CHARACTER SET UTF8
  6. FIELDS TERMINATED BY',' ENCLOSED BY '"'
  7. LINES TERMINATED BY 'n' IGNORE 1 LINES");
  8.  
  9. CREATE TABLE `zmi064_02` (
  10. `Material` varchar(11) CHARACTER SET utf8 DEFAULT NULL,
  11. `Material Description` varchar(60) CHARACTER SET utf8 DEFAULT NULL,
  12. `MatType` text CHARACTER SET utf8,
  13. `MatGrp` text CHARACTER SET utf8,
  14. `ClassType` text CHARACTER SET utf8,
  15. `Class type Text` text CHARACTER SET utf8,
  16. `Class` text CHARACTER SET utf8,
  17. `Class Text` text CHARACTER SET utf8,
  18. `CharactName` text CHARACTER SET utf8,
  19. `CharactValue` text CHARACTER SET utf8,
  20. `Plant` varchar(6) CHARACTER SET utf8 DEFAULT NULL
  21. ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
  22.  
  23. character_set_client utf8
  24. character_set_connection utf8
  25. character_set_database utf8
  26. character_set_filesystem binary
  27. character_set_results utf8
  28. character_set_server utf8
  29. character_set_system utf8
  30. collation_connection utf8_general_ci
  31. collation_database utf8_unicode_ci
  32. collation_server utf8_general_ci
  33.  
  34. Invalid utf8 character string: 'LUG'
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement