Book a Demo

Author Topic: Creating oracle tables with varchar2(X CHAR)  (Read 2589 times)

demirlero

  • EA Novice
  • *
  • Posts: 1
  • Karma: +0/-0
  • I love YaBB 1G - SP1!
    • View Profile
Creating oracle tables with varchar2(X CHAR)
« on: May 14, 2007, 06:22:44 am »
Hi;
I have a problem with EA interface, I am trying to create a data base table(oracle) as varchar2(X CHARS), I am not able to do it via interface, but if i revers engineer table from my data base EA understands it correctly and shows it as varchar2(X CHAR) in diagram, but I can not see any difference on column details as well.
Does someone knows how to define this type columns via EA interface?
Thanks for help
Ongun

hd

  • EA Administrator
  • EA User
  • *****
  • Posts: 312
  • Karma: +0/-0
    • View Profile
Re: Creating oracle tables with varchar2(X CHAR)
« Reply #1 on: May 14, 2007, 06:06:55 pm »
For the tables successfully imported...

  • Open the Tagged Values window (Ctrl+Shift+6)
  • highlight the column involved
  • check the value of LengthType tag (CHAR or BYTE)


So, to create a column with VARCHAR2(50 CHAR) datatype, create a column with a VARCHAR2(50) datatype, then add a tag 'LengthType' to that column with value 'CHAR' or 'BYTE'.

The help file will be updated with this missing information.