Oracle column definitions / byte and char

General discussion forum about all databases other than SqlBase.
Georg Frueh
Posts: 38
Joined: 20 Mar 2017, 15:58
Location: Germany

Oracle column definitions / byte and char

Post by Georg Frueh » 07 Feb 2008, 17:43

TD41 ptf2, Oracle 10g

Normaly we create table columns in bytes like the following statement:
create table test1 (Column1 varchar2 ( 85 byte) );
In this case we can select the columns into a Stringvariable until 256 bytes.

Now a customer DBA create the table columns in Char:
create table test2 (Column1 varchar2 ( 85 char) );
Here we cannot select the column in a Stringvariable. We need an Long string because oracle reserves 3 byte per char.

Has anybody a solution or a workaround for this problem?

Thanks in advanced


Return to “General Discussion”

Who is online

Users browsing this forum: [Ccbot] and 0 guests