Which one should I use: varchar() or char()?

From: Ramon F Herrera <ramon_at_conexus.net>
Date: Sun, 4 Oct 2009 05:53:30 -0700 (PDT)
Message-ID: <72dc42cb-ac80-474e-8832-78886de868ab_at_g1g2000vbr.googlegroups.com>

I inherited a bunch of database tables and just noticed that for historical reasons, one of the important tables has records based on varchar(), and the other on char().

Note: I have never been able to come to grips with PL/SQL and essentially all my database access (except for table creation and table loading) is done through Pro*C/C++.

What are the trade-offs between char() and varchar()? Which one should I use?


-Ramon Received on Sun Oct 04 2009 - 07:53:30 CDT

Original text of this message