MAJOR SQL QUESTION!!!!!

[imported_Rogie]

MySQL - Why do I get Data truncated error messages?

 

[Markbnj]

Originally posted by: DannyLove
college kiddies who can't do their own homework, priceless

Winner.

And yes, the truncation error is almost certainly because the data won't fit when the extra char is padded on. He did mention somewhere along in there that it was a char field. The contents of a char field are the full width of the char field, regardless of what you put in it. So unless I'm wrong, or he's wrong, this will fail every time, for every row.

OP, I really don't care if you're asking for homework help or not, but please, next time post a complete description of the problem, instead of unpunctuated one-liners.

Your problem is a little more complicated if the field is a char field. You have to replace the character at the correct place in the field with your new character. SQL has all the necessary functions, and they are well-documented.

 

[KeyserSoze]

Originally posted by: DannyLove
college kiddies who can't do their own homework, priceless

LOL. I know DarkStar, and he isn't a college kiddie asking for a homework assignment.

DS, ping me next time.




KS