Perhaps it would make sense to use the maximum VARCHAR length (32672)?
+1 I prefer the longer-columns solution to the truncate-the-values solution. thanks, bryan P.S. Thanks Stephan for investigating these problems! I'm looking forward to your proposed fixes.
