Varchar in SQL to VFP data field

[madhatter2002]

Just a quick one tipsters.

What is the maximum length that a sql varchar data type can hold for a string??

Can a VFP data field match the length of sql varchar data type when the varchar is already at its max?? or do i need to cut it into multiple parts before I can save it VFP data fields?

 

[Mike Lewis]

It depends on the back end. In SQL Server, the max length of a Varchar is 8,000, but that's necessarily true for other servers.

In general, if a Varchar is more than 254 characters, VFP will map it to a memo field. You never need to cut the field into multiple parts.

Mike


Mike Lewis
Edinburgh, Scotland

My Visual Foxpro web site:

http://www.ml-consult.demon.co.uk

My Crystal Reports web site:

http://www.ml-crystal.com