Re: Structure Type Text

[Phillip Ward]

Quote

I have imported a .CSV file into a database

You say "CSV file", I immediately think "MS Excel", which is just chock full of "helpful" features that can completely foul up your data.

First things first. Check that the CSV file really looks the way you think it should. Open it in [something like] Notepad. Make sure it looks right there. (Excel can "helpfully" format things to "look" right on screen but that are wildly different in the physical file).

Then check the definition of the table you're loading ("show create table abc \g").

If any of your fields are defined as Integer (or any of the *Int variation), then MySql will "try" to convert the incoming data into valid numbers - by dropping any the letters! This would explain your "03" becoming "3", your "8Y" becoming "8".

Regards, Phill W.