DataType [message #7863] |
Mon, 14 July 2003 02:11 |
santoshi
Messages: 7 Registered: May 2003
|
Junior Member |
|
|
hi
i have my data which is of length 450 characters, i have a column varchar2(450),but this is storing onle 256 charecter is any other data type which holds more 256 character please help me out,
thank u
priya
|
|
|
Re: DataType [message #7866 is a reply to message #7863] |
Mon, 14 July 2003 02:49 |
Nalaneelan
Messages: 12 Registered: June 2003
|
Junior Member |
|
|
Priya,
Varchar2 will hold characters more than 450 characters.
i.e., upto 4000.
Using varchar2 is good enough for storing 450 characters.
|
|
|
Re: DataType [message #7869 is a reply to message #7863] |
Mon, 14 July 2003 03:31 |
Sheshadri
Messages: 12 Registered: June 2002
|
Junior Member |
|
|
Hi,
Data that you are storing in database also depents on the characterset that you are using.
check out which character set and which language you are using.
Any way you can increase the size by
Alter table <TNAME> modify <Col.Name> varchar2(1000);
but you cannot decrease it unless you do not have any rows in the table
bye
shesha
|
|
|
Re: DataType [message #7882 is a reply to message #7869] |
Tue, 15 July 2003 02:08 |
santoshi
Messages: 7 Registered: May 2003
|
Junior Member |
|
|
thanks for replying.
i am using VC++ as prog.language
i increased the size but still it not storing more than 256 characters. plz help me out.
priya.
|
|
|