Issue 85785

Summary: Can't adjust lengh of char columns with JDBC and Oracle/Informix
Product: Base Reporter: bdonauba <bdonauba>
Component: codeAssignee: AOO issues mailing list <issues>
Status: CONFIRMED --- QA Contact:
Severity: Trivial    
Priority: P3 CC: issues, kluck-buchholz, mechtilde
Version: OOo 2.3   
Target Milestone: ---   
Hardware: PC   
OS: Linux, all   
Issue Type: DEFECT Latest Confirmation in: ---
Developer Difficulty: ---

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