List:General Discussion« Previous MessageNext Message »
From:Martin Ramsch Date:August 19 1999 9:16pm
Subject:Re: VARCHAR & CHAR Bug ??
View as plain text  
On Thu, 1999-08-19 16:51:58 -0400, Darren l Sweeney wrote:
> "A variable length string that is stored with its length. All end space are
> removed when storing it. Maximum range 1 - 255 characters. Is sorted and
> compared case insensitively unless the binary keyword is given." 
> 
> But if you try this it auto converts the field to CHAR ??
> 
> CREATE TABLE test10 (
> br_state varchar(3)
> );

Well, I don't see how the quoted paragraph connects to your problem,
but there _is_ something helpful about it in the manual in
chapter "7.6.1 Silent column specification changes" ...

Regards,
  Martin
-- 
Martin Ramsch <m.ramsch@stripped> <URL: http://home.pages.de/~ramsch/ >
PGP KeyID=0xE8EF4F75 FiPr=52 44 5E F3 B0 B1 38 26  E4 EC 80 58 7B 31 3A D7
Thread
VARCHAR & CHAR Bug ??Darren L Sweeney19 Aug
  • Re: VARCHAR & CHAR Bug ??Martin Ramsch19 Aug
  • VARCHAR & CHAR Bug ??sinisa20 Aug
RE: VARCHAR & CHAR Bug ??Paul Comber20 Aug