Home » RDBMS Server » Server Administration » Char(10) vs Varchar2(10)
Char(10) vs Varchar2(10) [message #176602] Thu, 08 June 2006 20:52 Go to next message
jerryhaley
Messages: 2
Registered: June 2006
Location: PA
Junior Member
I have a column that will always have 10 alphanumeric characters. Should I use the varchar2 datatype or char datatype? Does a varchar2 datatype have extra bytes of overhead to store the lenght? I want to establish a standard in our department at work. Thank you.

Report message to a moderator

Re: Char(10) vs Varchar2(10) [message #176605 is a reply to message #176602] Thu, 08 June 2006 21:20 Go to previous messageGo to next message
BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal
Senior Member
Choose VARCHAR2 awlays.
If you use CHAR, folks will never forgive you.

Report message to a moderator

Re: Char(10) vs Varchar2(10) [message #176624 is a reply to message #176605] Fri, 09 June 2006 00:10 Go to previous message
Littlefoot
Messages: 21818
Registered: June 2005
Location: Croatia, Europe
Senior Member
Account Moderator
On the contrary, CHAR datatype is more likely to waste extra disk space. Why? Read about it here.

Report message to a moderator

Previous Topic: creating one more database.
Next Topic: Oracle 8.17 Import problem (Character set issue)
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Fri Sep 20 12:25:23 CDT 2024
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.