[Solar-talk] db exception on size exceeded

[Jeff Surgeson]

Hi Guys

> >> I might be wrong but I would imagine that the chances of max data
> >> lenghts
> >> being exceeded are high especialy with shorter values and I have
> >> never known
> >> mysql to choke on it own on length other than to truncate the data.
> >
> > I think that's a point of contention with a lot of folks; some
> > purists say that MySQL *should* choke on too-long data instead of
> > silently truncating.
>
> Exactly. Mysql blindly truncating is such a headache. If I have a hole
> in my app and it's accepting data that is too large for the db then by
> all means let mysql fuss at me about it. That way I can fix the hole. I
> hate discovering those things when a user asks  "Why won't my title save
> no matter what I put into it?"

Thanks, by listening you learn, I realize that I need to pay more attention to 
correct data length as part of my validation, which I was not doing.

-- 
Jeff Surgeson

-- 
Jeff Surgeson