[Solar-talk] db exception on size exceeded

[Richard Harding]

Paul M Jones wrote:
> On Jul 16, 2006, at 6:51 PM, Jeff Surgeson wrote:
> 
>> 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?"

Rick