| datatype [message #68501] |
Tue, 23 December 2003 20:50  |
aril
Messages: 11
Registered: June 2003
|
Junior Member |
|
|
hi,
i've got a question regarding datatype in oracle 9i, what is the differences between varchar2, nchar, nvarchar2.
What are the suitable datatype for each of below:
1) 123
2) aril
3) sha'rani
Those are example of data that i would like to store into a table on oracle 9i.
hopefully members' of this forum will help me. thank you.
|
|
|
|
| Re: datatype [message #68504 is a reply to message #68501] |
Sun, 28 December 2003 21:17  |
Frank Naude
Messages: 4593
Registered: April 1998
|
Senior Member |
|
|
Hi,
See the Oracle SQL Reference Guide for a description of all the available data types. In short:
varchar2 - Variable-length character string
nvarchar2 - Variable-length character string - use the defined national character set
char - Fixed-length character data (Oracle blank-pads the value to column length)
nchar - Fixed-length character data - use the defined national character set
You can start with the following data types:
1) number
2) varchar2
3) varchar2
Best regards.
Frank
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
