Re: [GENERAL] view columm size.....

"Ross J. Reedstrom" a écrit :

> On Thu, Feb 10, 2000 at 10:31:18AM +0100, Arnaud FLORENT wrote:
> > hi,
> >
> > i 've create a view
> > one of the column is the result of col1 || col2.....
> > col1 is 8 char long
> > col 2 is 4 char long
> >
> > but my column view is 254 char long........
> >
> > so i can't UPDATE a 12 char length col using this view a table because
> > "Length is not equal to length of the target column"
> >
> > what should i do to force the length of the view column to 12 char?
> >
>
> Hmm, try something like:
>
> substr("ColView",1,12)
>
> That should give you the first 12 characters, i.e. all of them. See if
> the UPDATE likes it.

this works but i would like to understant this behaviour......

i've got the same problem with a select into
MAX( <char(12) column>) becomes a char (8190)!!!!!!!!!!!!

this column should be used as a joined key, and the join gave no results....

--
______________________________
Arnaud FLORENT
IRIS Technologies

phone: (33) 03 20 65 85 80
fax: (33) 03 20 65 85 81
GSM: (33) 06 15 14 32 90

mailto:aflorent(at)iris-tech(dot)fr
______________________________