[ http://nagoya.apache.org/jira/browse/DERBY-52?page=comments#action_55055 ] Satheesh Bandaram commented on DERBY-52: ----------------------------------------
I believe the documentation is wrong here... The maximum size of CHAR allowed in Derby is 254, so the documentation needs to be changed. > Cannot create CHAR column with size greater than 254 > ---------------------------------------------------- > > Key: DERBY-52 > URL: http://nagoya.apache.org/jira/browse/DERBY-52 > Project: Derby > Type: Bug > Components: SQL > Versions: 10.0.2.0 > Environment: Dell Dimension 2350, 2GHz P4, 1 Gig RAM, > Window XP Pro Version 2002, SP2 > JDK 1.4.2_03, build 1.4.2_03-b02 > Derby Snapshot SVN version 46005 (Binaries) > Reporter: Jason Palmatier > > An attempt to create a table that contains a column of type CHAR with a size > greater than 254 using the SQL statement > CREATE TABLE dummyTable ( column1 char(255),column2 char(10),column3 char(10) > ) > results in the following SQL Exception: > SQL Exception: The length, precision, or scale attribute for column, or type > mapping 'CHAR(255)' is not valid. > SQL Error: 30000 > SQL State: 42611 > However, if you decrease column1's length by one as below, the table is > created successfully: > CREATE TABLE dummyTable ( column1 char(254),column2 char(10),column3 char(10) > ) > The Derby Reference Manual states that the limit on the length of a CHAR data > type is java.lang.Integer.MAX_VALUE: > http://incubator.apache.org/derby/manuals/reference/sqlj128.html#HDRSII-SQLJ-13733 -- This message is automatically generated by JIRA. - If you think it was sent incorrectly contact one of the administrators: http://nagoya.apache.org/jira/secure/Administrators.jspa - If you want more information on JIRA, or have a bug to report see: http://www.atlassian.com/software/jira
