我试图将签名存储在数据库中。 我正在使用从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..
更多推荐
发布评论