>>>>>>>>>>>> Kristian Waagan wrote (2008-11-25 13:36:54): > tom_ wrote: >> Hello Kristian, >> >> this is a good idea, truncating by java before writing by SQL. Yes, varchar >> removes trailing blanks, though it would help if it would cut larger values >> instead of not writing them. If you have a look at the error message it >> shows that he tries to cut the value to the limit but has an exception. >> > > Yes, it is trying to cut, but is not allowed to do so because the data > to be cut consists on non-blanks. > There is no support for allowing Derby to truncate "real data". You > could add a feature request to Jira[1], but since there are relatively > simple work arounds available, I don't know if it will get much traction > in the community.
Another thing, I don't think increasing the size of the VARCAHR in Derby should affect Derby performance. -- Bernt Marius Johnsen, Staff Engineer Database Technology Group, Sun Microsystems, Trondheim, Norway
signature.asc
Description: Digital signature
