If i have a
column A with type VARCHAR(10);
and
column B with type TEXT;
I then insert "ABCDEFGHIJ", which is a string of length 10. Would it take up more space in DB when inserted into column B compared to column A?
I always have the idea that TEXT datatype takes up more reserve space (before any thing is inserted) in PostgreSQL and thus always went for VARCHAR. Unfortunately most of the time, i cannot control the length of the string that is coming into the database.
Please explain. Even if i am right, please say so because i am confused.
Regards
Mian
postgeSQL datatype Text question
Moderator: General Moderators
- feyd
- Neighborhood Spidermoddy
- Posts: 31559
- Joined: Mon Mar 29, 2004 3:24 pm
- Location: Bothell, Washington, USA
this may be of some information: http://www.phpfreaks.com/postgresqlmanu ... acter.html