Is there a restriction on the maximum number of characters to be entered in a co

bruceh over 10 years ago

Is there a restriction on the maximum number of characters to be entered in a constant of data type 'text'? This constant is passed to a sql statement. We seem to be limited at ~100 characters. Values after the100 character limit are not passed in. This causes no error other than an incomplete query result. thanks....

Discussion posts and replies are publicly visible

Parents

0 bruceh over 10 years ago

Our constant length is under the cap (using your method) so the configuration setting is ok. We found a char(100) limit within our sql that was causing the problem. thanks again.
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel

Reply

0 bruceh over 10 years ago

Our constant length is under the cap (using your method) so the configuration setting is ok. We found a char(100) limit within our sql that was causing the problem. thanks again.
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel

Children

No Data