- Original Message -
From: "Pahlevanzadeh Mohsen" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Wednesday, September 08, 2004 6:59 PM
Subject: varchar or
> Dears,I'm going to create a field what it not limited
> to a specefy size.
>
Dears,I'm going to create a field what it not limited
to a specefy size.
Please guide me
=
-DIGITAL SIGNATURE---
///Mohsen Pahlevanzadeh
Network administrator & programmer
My home phone is: +98213810146
My email address is
On Sun, 1 Jun 2003 14:53:54 +0100, Dan wrote:
> I have used varchar for ALL my fields as this is the only one i know.
>
> Alot of my rows just contain image link text ie.
>
> /image/logoa.gif
>
> Is using varchar overkill for these fields?. Would i be better using
> something else?
It depends
i.e.16 chars, make it 30 to be sure
"it" = CHAR
- Original Message -
From: "Jerry" <[EMAIL PROTECTED]>
To: "Dan" <[EMAIL PROTECTED]>
Cc: <[EMAIL PROTECTED]>
Sent: Sunday, June 01, 2003 3:10 PM
Subject: Re: Using varchar or something el
;[EMAIL PROTECTED]>
Sent: Sunday, June 01, 2003 2:53 PM
Subject: Using varchar or something else?
I have used varchar for ALL my fields as this is the only one i know.
Alot of my rows just contain image link text ie.
/image/logoa.gif
Is using varchar overkill for these fields?. Would i be
I have used varchar for ALL my fields as this is the only one i know.
Alot of my rows just contain image link text ie.
/image/logoa.gif
Is using varchar overkill for these fields?. Would i be better using something else?
Any advice?
TIA
Dan
ps. for my row which contains numbers it seems i c
s not.
>
> --Matthew
>
> >>> "Nick Kostirya" <[EMAIL PROTECTED]> 01/26/01 11:42AM >>>
> Hi.
>
> You would tell me who is quicker: CHAR(*), VARCHAR(*) or TINYTEXT.
> I need to qu
.but in most cases not.
--Matthew
>>> "Nick Kostirya" <[EMAIL PROTECTED]> 01/26/01 11:42AM >>>
Hi.
You would tell me who is quicker: CHAR(*), VARCHAR(*) or TINYTEXT.
I need to quicken DB to the maximum and to keep minimum size of the DB.
Thanks.
Nick.
Hi.
You would tell me who is quicker: CHAR(*), VARCHAR(*) or TINYTEXT.
I need to quicken DB to the maximum and to keep minimum size of the DB.
Thanks.
Nick.
-
Before posting, please check:
http://www.mysql.com/manual.php