The different databases define and handle VARCHAR types differently.
MySQL documentation states:
"Values in VARCHAR columns are variable-length strings. The length can be
specified as a value from 0 to 255 before MySQL 5.0.3, and 0 to 65,535 in 5.0.3
and later versions."
So, the valid lengths fo
Keith Bellairs wrote:
I think that depends on the DB. Using VARCHAR at least gives the engine
a chance to optimize storage. CHAR is good for truly fixed length strings.
This is true, I mixed up the varchar with the char. Adding a limit to
varchar is entirely arbitrary though, if the varchar c
I think that depends on the DB. Using VARCHAR at least gives the engine a
chance to optimize storage. CHAR is good for truly fixed length strings.
On Feb 18, 2008 3:56 PM, Graham Leggett <[EMAIL PROTECTED]> wrote:
> Phil Longstaff wrote:
>
> > Well, as I originally said, I can use a TEXT type whi
Phil Longstaff wrote:
Well, as I originally said, I can use a TEXT type which allows up to 64K
byte strings. Although not unlimited, I assume this is long enough for
everyone's purposes. MySQL stores them as 2byte length + chars. I will
need to check that that libgda has some good method of
