search envelope-o feed check
Home Unanswered Active Tags New Question
user comment-o

After import csv, cant see events in calendar

Asked by Anonymous
7 years ago.

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.

This question is more than 1 months old and has been closed. Please create a new question if you have anything to add.