[BATCH-2091] Declare DDL with VARCHAR( n char) Created: 02/Sep/13  Updated: 17/Dec/19  Resolved: 29/Oct/18

Status: Resolved
Project: Spring Batch
Component/s: Infrastructure
Affects Version/s: 2.2.1, 3.0.9, 4.0.1, 4.1.0.RC1
Fix Version/s: 4.1.0

Type: Improvement Priority: Major
Reporter: David J. M. Karlsen Assignee: Mahmoud Ben Hassine
Resolution: Complete Votes: 0
Labels: None
Remaining Estimate: Not Specified
Time Spent: Not Specified
Original Estimate: Not Specified

Issue Links:
is duplicated by BATCH-2731 java.sql.SQLException: ORA-12899: val... Resolved
is duplicated by BATCH-2750 The EXIT_MESSAGE columns of BATCH_JOB... Resolved
Reference URL: http://gerardnico.com/wiki/database/oracle/byte_or_character


It's better to declare the ddl with varchar2(10 char) than varchar2(10) to be dependent on the number of characters and not bytes. This is important when using multibyte charsets like UTF8.


Comment by David J. M. Karlsen [ 15/Oct/13 ]

Why won't you comment on this one?

Comment by Michael Minella [ 06/Mar/14 ]

Please see my comments in the related pull request.

Comment by Mahmoud Ben Hassine [ 29/Oct/18 ]

This has been resolved with this commit and documented here.

Comment by Spring Issuemaster [ 17/Dec/19 ]

The Spring Batch Framework has moved from Jira to GitHub Issues. This issue was migrated to spring-projects/spring-batch#1508.

Generated at Fri Aug 14 14:47:23 UTC 2020 using Jira 8.5.4#805004-sha1:0444eab799707f9ad7b248d69f858774aadfd250.