Max length of TEXT data type is returned incorrectly

[EitanBlumin]

The max length value is taken from INFORMATION_SCHEMA, where the character max length is incorrect for the data type.

discovered by Nathan Lifshes

[Rap70r]

Hello,

I tried this fix but the script is producing null output for several tables.
I think this happens when there are null values in the temp table.

[EitanBlumin]

@Rap70r I don't think this script is supposed to work on temp tables.

If you're not referring to actual temp tables, then please provide scripts and steps to reproduce.

Thanks.

[Rap70r]

Hi EitanBlumin,

I was referring to @MainDefinition in the actual script.
I added a where condition and it worked fine.

SELECT @Result = @Result + CHAR(13) + FieldValue FROM @MainDefinition WHERE FieldValue IS NOT NULL

[Rap70r]

Hi EitanBlumin,

I think latest release doesn't include below changes:

18bba20

Is that intentional?

Thank you

[EitanBlumin]

No, not really intentional.

But while we're at it, perhaps we could throw in a few more fixes.

Could you perhaps fork the repository and create a pull request with your suggested fix?