Issue 85785 - Can't adjust lengh of char columns with JDBC and Oracle/Informix
Summary: Can't adjust lengh of char columns with JDBC and Oracle/Informix
Alias: None
Product: Base
Classification: Application
Component: code (show other issues)
Version: OOo 2.3
Hardware: PC Linux, all
: P3 Trivial (vote)
Target Milestone: ---
Assignee: AOO issues mailing list
QA Contact:
Depends on:
Reported: 2008-02-01 06:33 UTC by bdonauba
Modified: 2013-08-07 15:45 UTC (History)
3 users (show)

See Also:
Issue Type: DEFECT
Latest Confirmation in: ---
Developer Difficulty: ---


Note You need to log in before you can comment on or make changes to this issue.
Description bdonauba 2008-02-01 06:33:56 UTC

I tried to create a table in Oracle 9 and Informix IDS 10 but it is not 
possible to change the length of char columns. The result are char columns 
with length 1.

DDL Example:
create table "bdonauba".t2
    id integer,
    data char(1) not null

I've done that with different versions of JDBC drivers.

The same problem exists if I copy data from calc into base. The assistant 
opens but I can't adjust the size of char,varchar,... columns. The field is 
not enabled.

Bernhard Donaubauer
Comment 1 Mechtilde 2008-05-20 13:12:14 UTC
add to CC

please confirm
Comment 2 oracelix 2008-05-20 16:48:45 UTC
Full confimation.

Also with OOo 2.4 and Oracle 10g I'm not able to increase or decrease the 
length of fields. This is for integer and char fields.

It's definitely not a prob of jdbc driver, I think.

It's the same with WinXP.

Comment 3 Mechtilde 2008-05-20 21:23:56 UTC
I set the flags after confirming of oracelix
Comment 4 Mechtilde 2008-05-20 21:41:44 UTC
reassign to developer of the dba team
Comment 5 ocke.janssen 2008-12-10 07:33:37 UTC
Set target