Home » RDBMS Server » Enterprise Manager » datatype
datatype [message #68501] Tue, 23 December 2003 20:50 Go to next message
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 Go to previous message
Frank Naude
Messages: 4571
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
Previous Topic: OEM Intelligent Agent on a NON-DB server
Next Topic: error : create database link version 8.1.5 for NT
Goto Forum:
  


Current Time: Fri May 20 15:19:19 CDT 2022