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?

Thx,

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

This message: [ Message body ]
Next message: Ramon F Herrera: "Anyone out there successfully using Pro*C/C++ in C++ mode?"
Previous message: Mladen Gogala: "Re: 11g, Unable to do nolog operations"
Next in thread: Palooka: "Re: Which one should I use: varchar() or char()?"
Reply: Palooka: "Re: Which one should I use: varchar() or char()?"
Maybe reply: gazzag: "Re: Which one should I use: varchar() or char()?"
Reply: Walt: "Re: Which one should I use: varchar() or char()?"

Contemporary messages sorted: [ by date ] [ by thread ] [ by subject ] [ by author ]

Original text of this message