cmd1. The Parameters. The Add (" @ ZiduanValueKey, "OleDbType VarChar, 250). The Value=https://bbs.csdn.net/topics/editZiduanValue; 

The field type is note, anyway could content many indefinite length, I now set 250, then how to modify can maximize, in theory, can save a lot of?

Don't change the number how can I modify to achieve similar note that save a lot of bytes? Thank you very much!

Add a question, if not ACCESS database, achieve the same purpose, here how to change?

CodePudding user response:

Cmd1. The Parameters. The Add (" @ ZiduanValueKey, "OleDbType. VarChar). Value=https://bbs.csdn.net/topics/editZiduanValue;

CodePudding user response:

reference 1st floor webjock response:

cmd1. The Parameters. The Add (" @ ZiduanValueKey, "OleDbType. VarChar). Value=https://bbs.csdn.net/topics/editZiduanValue;

you mean remove digital is not limit?

CodePudding user response:

To spread value varchar (Max) or nvarchar (Max) type how, in fact as long as can be set to 1 length
https://www.cnblogs.com/kdp0213/p/8554032.html