Variable length text field

Variable length text field

Post by Kevin Meie » Wed, 15 Jan 1997 04:00:00

I am an Ex-Clipper programmer and I am trying to create an application
using Delphi and MS SQL Server 6.5.  In Clipper, there is a 'Memo' datatype
that is variable length allowing me to use it to store general text
information.  Is there an equivalent datatype in MS SQL Server?

Kevin Meier


Variable length text field

Post by Neil Pik » Wed, 15 Jan 1997 04:00:00


varchar for up to 255 characters.  Over that, there is a TEXT type.

 Protech Computing Ltd (MS Solution Provider)
 Using Virtual Access 3.52 build 159c (32-bit) on NT 4.0 SP2


Variable length text field

Post by Jose Nuno A.P.S. Ferreir » Thu, 16 Jan 1997 04:00:00

Note that there is a BUG on TEXT columns, though.

{ :)  Jos=E9 Nuno de Abreu Pires dos Santos Ferreira  :( }
{                                                      }
{ PESSOAL / PERSONAL --------------------------------- }

{                                                      }
{ EMPREGO / JOB -------------------------------------- }
{      Home Page: }

{                                                      }


1. Variable Length Text Fields

I can't find any reference to whether or not the maximum length of a
variable length string is actually allocated in the database or not.  ie.
If I define a variable length field, and default it to its largest size of
255 chars, does it take up 255 or possibly more characters in the database
for the word "Hello", or just however much it needs.  I've searched and
searched for this answer in help files and MSDN, but can't find it.  Any
help appreciated.  Thanx!


Jesse Warford

2. 4 INFORMIX-questions

3. Fixed field text, and variable length last field

4. Win2K & DAO does not work in a network environment

5. Variable # of fields or variable lengths?

6. A new Product from Informix - 4GL++ ??

7. plpgsql - accessing field in RECORD variable by text variables

8. PivotChart - can't put dynamic values/percentages

9. Reading Variable Length Text file

10. Variable Length Text in SQL2000

11. DTS and variable length text files

12. Importing a variable length text file