|
| PORTAIL | ANNUAIRE | ARTICLES | COMPARATEUR HÉBERGEURS | DEVIS | FORUMS | RÉDUCTEUR D'URL |
|
05/10/2007, 14h31
|
#1 |
Messages: n/a
Hébergeur: |
VARCHAR and size
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 |
|
|
06/10/2007, 11h37
|
#2 |
|
Messages: n/a
Hébergeur: |
Re: VARCHAR and size
varchar( 255 ) is the max size i know for this colmun type.
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 |
|
|
|
06/10/2007, 23h30
|
#3 |
|
Messages: n/a
Hébergeur: |
Re: VARCHAR and size
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! |
|
|
|
06/10/2007, 23h56
|
#4 |
|
Messages: n/a
Hébergeur: |
Re: VARCHAR and size
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'; |
|
|
 |
| Outils de la discussion | |
|
|
