Hi, I just noticed a strange thing while using mysql (running in console mode). I LOADed data from a text file and then displayed the contents using SELECT, but the first column of data seems truncated on display and the rest are fine. However, if I only select the first column, it displays correctly. So the data gets in, but displays strangely.
However, if I add a row to a table one at a time using INSERT and then display, everything looks ok.
Has anyone seen the same thing? What can I do to see the data correctly?
Thanks.
However, if I add a row to a table one at a time using INSERT and then display, everything looks ok.
Has anyone seen the same thing? What can I do to see the data correctly?
Thanks.