On 6 Oct, 22:30, "Paul Lautman" <paul.laut...@btinternet.com> wrote:
> Séverin Richard wrote:
> > Marco wrote:
> >> Hello to anyone,
> >> I need to get the max number of char I can store into a varchar
> >> variable. Is there any function I can use?
> >> ex.
> >> DECLARE MYVAR CHAR(3)
>
> >> ThefunctionThatLetMeKnowTheSizeOf(MYVAR) = 3
>
> >> thanks
> >> Marco
> > varchar( 255 ) is the max size i know for this colmun type.
>
> Please do not top post. (Top posting fixed)
>
> And you have not answered the question that was asked!

SHOW COLUMNS FROM my_table WHERE `FIELD` = 'my_char_field';