Semantics of varchar2 and Trafodion varchar data type are not same. Varchar2
stores NULL value for empty input string where as Trafodion stores empty
string. I think handling trailing spaces is also different. A new FSData type
has be added to support VARCHAR2 in Trafodion for seamless migration of Oracle
application than making it an alias to Trafodion.
Regards,-Ravisha
On Thursday, October 27, 2016 8:19 PM, Eric Owhadi <[email protected]>
wrote:
+1 on this,
Eric
-----Original Message-----
From: Liu, Ming (Ming) [mailto:[email protected]]
Sent: Thursday, October 27, 2016 9:41 AM
To: [email protected]
Subject: Is it good idea to add VARCHAR2 as an alias for VARCHAR?
Hi, all,
As fa as I know, today, Oracle users use VARCHAR2 heavily, it seems VARCHAR is
not ever used in Oracle DDL. So there is a task to rewrite Oracle DDL to
replace VARCHAR2 into VARCHAR when migrating from Oracle to Trafodion. So I
feel Oracle users will be happy to have VARCHAR2 supported in Trafodion if we
can.
IMHO, it will be very simple to add VARCHAR2 keyword as an alias for VARCHAR,
the effort seems minimal. So I want to ask the community about more input, is
there any considerations that I overlook , that, this alias will bring some
issues?
Some users I talked show the desire that Trafodion should support more Oracle
syntax, because it helps adoption, people are used to one of the major RDMBS
already, so happy to see something familiar.
I would like to see if community has desire to support some popular Oracle
syntax/functions in Trafodion? And I am happy to get more ideas about Trafodion
to be more easy to play with.
Thanks,
Ming
