Thank you for the link, it answered to my question.

Fulvio Senore

Martijn Tonies ha scritto:

> Hi,
>
>
>> I am designing a table that will contain a lot of rows. Each row will
>> have a "NOTES" column, that will contain user notes about that row. I
>> think that I will allow a maximum size of about 1000 bytes in that column.
>>
>> I expect that most users will not use the NOTES column at all, and those
>> that will use it will only put some text in a very low number of rows.
>>
>> In the end most rows will have a NULL value in the NOTES column.
>>
>> My problem is: is it better to use a BLOB or a VARCHAR data type for the
>> NOTES column? Is there any reason to prefer one solution to the other?
>> Using a VARCHAR looks like a simpler solution, but does it have drawbacks?
>>
>
> Have a read here:
> http://www.volny.cz/iprenosil/interbase/ip_ib_strings.htm
>
> Martijn Tonies
> Database Workbench - development tool for Firebird and more!
> Upscene Productions
> http://www.upscene.com
> My thoughts:
> http://blog.upscene.com/martijn/
> Database development questions? Check the forum!
> http://www.databasedevelopmentforum.com
>
>
>
> ++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
>
> Visit http://www.firebirdsql.org and click the Resources item
> on the main (top) menu. Try Knowledgebase and FAQ links !
>
> Also search the knowledgebases at http://www.ibphoenix.com
>
> ++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
>
> Yahoo! Groups Links
>
>
>
>
>
>