Ads were blocked - no problem. But keep in mind that developing HeidiSQL, user support and hosting takes time and money. You may want to send a donation instead.

Warning error

kaprofile5's profile image kaprofile5 posted 2 weeks ago in Import/Export Permalink

Hello

I am having an issue when i export my grid row, and then import it again. It shows up with these warnings:

Warning (1265): Data truncated for column 'dmg_min1' at row 1398 */

Though it doesn't seem as if it effects the numbers in the data. How do I get rid of the errors though?

(turns up with tons of these warnings)

I am exporting it to a Excel csv. with ANSI (like shown in image 1) Importing it like shown in image 2 Then turn up with errors like image 3.

3 attachment(s):
  • Capture1
  • Capture2
  • Capture3
ansgar's profile image ansgar posted 2 weeks ago Permalink

"Data truncated" normmaly means the data in the file is longer than the column allows. You should check the definition of the columns from these warnings, and have a look at the data after importing.

Please login to leave a reply, or register at first.




Ads were blocked - no problem. But keep in mind that developing HeidiSQL, user support and hosting takes time and money. You may want to send a donation instead.