Re: Q:CASE Domains and datatypes
Date: 1995/06/02
Message-ID: <fkuyt.6.0014EA5B_at_iaehv.nl>#1/1
In article <3qlns2$nok_at_caesar.ultra.net> droth_at_dr.ultranet.com (David Roth) writes:
>From: droth_at_dr.ultranet.com (David Roth)
>Subject: Q:CASE Domains and datatypes
>Date: Thu, 01 Jun 1995 20:59:12 -0400 (EDT)
>I am trying to create a column with a CHAR data type.
>My entity/attribute format is CHAR
>I am using a domain with format and datatype both defined as CHAR.
>When I use default database design I get a table/column with datatype
>VARCHAR2(240).
>Why? CHAR is al egal datatype in V7.
>I can modify each column manually. But this is a real pain!
David,
Case V5.0 puts 'set compatibility V6' before every script that's run in an
O7 environment.
If you don't want VARCHAR2's you have to run the CREATE-script's outside Case
in SQLPLUS without that 'set'-statement.
Warning : RI-statements have changed between V6 en V7, so you could get problems there (and perhaps in other area's too).
Greetings,
Frank
Received on Fri Jun 02 1995 - 00:00:00 CEST