Why is TWideMemoField?

[Eden0928]

My Code:

Code: Select all

SELECT 'ABC ' || 'DEF' AS TEST

I get the "TEST" is TWideMemoField.
But, when get TWideStringField in MS SQL Server.

[AlexP]

Hello,

Such behaviour is due to that server doesn't send such field size, and if a string field ha no size, we map it to a Memo field. To solve the problem, you should enable the UnknownAsString option.

Code: Select all

SQLConnection.Params.Values['UnknownAsString '] := 'True';

[Eden0928]

Have other adverse effects it?

Code: Select all

SQLConnection.Params.Values['UnknownAsString '] := 'True';

[AlexP]

Hello,

If this setting is enabled, all the fields, that we cannot determine data type for, will be mapped as TStringField.