我应该给在JSON中存储签名的MYSQL VARCHAR字段多长？(What length should I give to a MYSQL VARCHAR field that stores a s

我应该给在JSON中存储签名的MYSQL VARCHAR字段多长？(What length should I give to a MYSQL VARCHAR field that stores a signature in JSON?)

我试图将签名存储在数据库中。 我正在使用从canvas转换为JSON的签名簿插件（ signaturePad ），现在要将签名存储在MySQL 。

我正在使用VARCHAR字段，但我不确定我应该允许哪个长度。 我试了好几次，通常最后会有一个2000到3000个字符的字符串。

题： 我应该在MYSQL中使用什么字段长度？ 我不知道如何CANVAS=>JSON转换完成，所以也许有人可以给我一个指向什么期望？

谢谢！

I'm trying to store signatures in a database. I'm using a the signature pad plugin (signaturePad) which converts from canvas to JSON and now want to store the signature in MySQL.

I'm using a VARCHAR field, but I'm not sure which length I should allow. I tried several times and usually end up with a string between 2000 and 3000 characters.

Question: What should I use for field length in MYSQL? I don't know how the CANVAS=>JSON conversion is done, so maybe someone can give me a pointer on what to expect?

Thanks!

最满意答案

我不会使用VARCHAR ，我会使用TEXT 。 这样做可能会牺牲性能，但您不必担心尺寸限制。

编辑：

另外， VARCHAR的最大值是VARCHAR(65535 ）。 在那里做一个笔记..

I would not use VARCHAR, I would use TEXT. You may sacrifice performance in doing this, but you won't have to worry about size constraints.

Edit:

Also, the maximum of VARCHAR is VARCHAR(65535). Just making a note there..