Michal Žeravík wrote:

>Does it mean VARCHAR are useless
>regarding to CHAR?
>Both have limit and rle compression.
>What is the difference then?
>
>
>

from char(200) if you insert value ('A' ), then select it, you will get 'A '
from varchar youll get 'A'

>Michal
>
>
>Ann W. Harrison wrote:
>
>
>
>>Adomas Urbanavicius wrote:
>>
>>
>>
>>
>>>So,
>>>As far as I understand the only varchar advantage is trimming of blank
>>>spaces of data, and disadvantages are disk space.
>>>
>>>
>>>
>>>
>>It also reduces the amount of data sent across the network for remote
>>access.
>>
>>Regards,
>>
>>
>>Ann
>>
>>
>>
>>
>>Yahoo! Groups Links
>>
>>
>>
>>
>>
>>
>>
>>
>>
>>
>>
>
>
>
>[Non-text portions of this message have been removed]
>
>
>
>
>Yahoo! Groups Links
>
>
>
>
>
>
>
>
>
>