| Data Length Semantics [message #151541] |
Thu, 15 December 2005 07:53  |
jayasree
Messages: 5
Registered: December 2005
Location: Hyderabad
|
Junior Member |
|
|
Hi Friends,
We are working on Forms9i, our database is NLS enabled (NLS_LENGTH_SEMNATICS is BYTE), so when we create a new table say
Create table emp (emp_no number,emp_name nvarchar2(30);
It is created as
SQL>desc emp
emp_no number
emp_name nvarchar2(90)
Now are trying to utilize the new feature of Data Length Semantics for emp_name field in the screen, so in the property pallate we gave the details as
Field Type : CHAR
Data Length Semantics : CHAR
Max Length : 30
Query Length : 0
At runtime, ideally it should accept 90 characters but in our case it is taking only 30.
Cud some one guide us as to where we are going wrong !!!
Thanks a lot in advance.
Rgds,
Jayasree.
|
|
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
