VARCHAR2 (.. CHAR) not supported in 8i?

[wzack]

Oracle 8i is rejecting the CHAR in VARCHAR2(80 CHAR) generated by EA.  Is CHAR only supported in 10g?
Thanks

[thomaskilian]

Oracle 8i is rejecting the CHAR in VARCHAR2(80 CHAR) generated by EA.  Is CHAR only supported in 10g?
Thanks

Shouldn't you ask in an Oracle forum?

[wzack]

Since EA is supposed to support Oracle and since this code was generated by EA I decided to ask it here.  Shouldn't EA generate valid code for a databas that it alleged to support?

[thomaskilian]

...  Shouldn't EA generate valid code for a databas that it alleged to support?

Of course. But your question was

Is CHAR only supported in 10g?

which is an Oracle related question. Maybe Bruno can help...

[Gary W.]

Wzack,

Does your application need to be concerned with representation in various languages (i.e. globalization) and /or different character sets?

The 'char' versus 'byte' qualification is new, and I'm pretty sure it wasn't in 8i.  That may be the problem right there...

How did you even get EA to generate this?  I did a quick test on a table with VARCHAR2 and CHAR columns and didn't get this additional NLS qualifier.

I'm on EA 6.0.778.. what version are you on?


Gary

[Bruno.Cossi]

Hi,

since Thomas invoked my name :-) The ability to declare varchar2 using either byte (default) or char semantics has been introduced in Oracle 9i and is also supported in 10g. I have not seen it generated from EA though, did you type it in the attribute details yourself?

Bruno

Oracle 8i is rejecting the CHAR in VARCHAR2(80 CHAR) generated by EA.  Is CHAR only supported in 10g?
Thanks

[donghwi]

I have a same problem and the CHAR come from the reverse engineering from the Oracle 8i.

I'd like to get rid of CHAR from display and also from the DDL generated from EA.

Would it be possible?

Thanks,
Dennis