> I am trying to determine when it is best to use
> varchar and when it is appropriate to use tinytext. I
> have looked at the manual and have read the difference
> between them but would like to have an understanding
> of this in more practical, real-life terms.
>
> Is a space between character
The answer to your question depends upon depends on the nature of the text
information you are going to store:
- The length of text you want to store.
- Database size and fragmentation considerations.
- Uppercase/Lower case significance
- Indexing (prior to 3.23).
> I am trying to determine w
Karen McAdams wrote:
> Is a space between characters considered a character
> in both column types or does one handle it
> differently?
Yes, it is a char.
>
> When I use a varchar I have to define its maximum
> length. I don't have to declare max length in
> tinytext. does this make a differen
