Devart Forums

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!

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