In the GetDataTypeAndSize procedure the system just ignores putting
the datasize for varchar fields that are larger than 255 long. It
has the data why doesn't it just put it in the size property like
other varchars, instead it just sets the type to ftMemo which is fine
but I really nead the size if it is a varchar and not a Blob.

Here is the piece of code I'm talking about:

begin
NewDataType := ftBytes;
NewDataSize := SQLLen;
end
else

>>>>>>>>>>>> HERE <<<<<<<<<<<<<<<<<<<

if SQLLen >= 256 then
NewDataType := ftMemo

>>>>>>>>> JUST ADD <<<<<<<<<<<<<<<<<<<<

NewDataSize := SQLLen;
else
begin
NewDataType := ftString;
NewDataSize := SQLLen;
// The vcl complains about zero length strings...
if NewDataSize = 0 then
NewDataSize := 1;
end;