varchar(max) vs. text

Discussion of open issues, suggestions and bugs regarding SDAC (SQL Server Data Access Components) for Delphi, C++Builder, Lazarus (and FPC)
Post Reply
Posts: 296
Joined: Thu 12 Oct 2006 09:34

varchar(max) vs. text

Post by Ludek » Thu 06 Aug 2009 09:35

Hi, I am working for years with columns of type "text". now, for some reasons (like trigger-based change protocolling) I need to change their type to varchar(max). are there any modifications in source needed? can the application designed on db with columns of type "text" work on similar database with columns of type "varchar(max)"? so that I can start it on sql 2000 with columns of type text and also on sql 2005 with these columns converted to varchar(max)? do i need to develop it on the type text-based database or can i use also the varchar(max) version?

thanks much for some tips!

Devart Team
Posts: 2885
Joined: Mon 05 Mar 2007 16:32

Post by Dimon » Fri 07 Aug 2009 07:25

SDAC for the text and varchar(max) SQL types creates the TMemoField field type, therefore you can use these SQL types as replaceable.

Post Reply