db-derby-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Bernt M. Johnsen" <Bernt.John...@Sun.COM>
Subject Re: varchar length
Date Tue, 25 Nov 2008 14:25:32 GMT
>>>>>>>>>>>> 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

View raw message