Hi I am using hotel reservation system. After importing values into table reservations ->
LOAD DATA LOCAL INFILE 'test.csv' INTO TABLE temp
CHARACTER SET utf16le
FIELDS TERMINATED BY ';\0'
LINES TERMINATED BY '\r\0\n\0';");
- If I use utf-8 or other , datetime is set to 0000-00-00 00:00:00 (not 2016-09-19 00:00:00).So this is the reason I am using utf16
I can see right values in database/tables. But no event is showing. I think it might do something with collation.