mysql的话,可以用text和longtext,操作方法如下:
1、首先点击“开始”菜单,打开Microsoft SQL Server Management Studio工具。
![](https://video.ask-data.xyz/img.php?b=https://iknow-pic.cdn.bcebos.com/8b13632762d0f703d6a776a018fa513d2697c5b1?x-bce-process=image%2Fresize%2Cm_lfit%2Cw_600%2Ch_800%2Climit_1%2Fquality%2Cq_85%2Fformat%2Cf_auto)
2、输入服务器IP地址、用户名和密码,连接到数据库。
![](https://video.ask-data.xyz/img.php?b=https://iknow-pic.cdn.bcebos.com/0df3d7ca7bcb0a46af3768457b63f6246b60afb1?x-bce-process=image%2Fresize%2Cm_lfit%2Cw_600%2Ch_800%2Climit_1%2Fquality%2Cq_85%2Fformat%2Cf_auto)
3、找到要存放Base64字段的数据库和表,这里选择“node”表。右键点击“node”表,在菜单中点击“设计”。
![](https://video.ask-data.xyz/img.php?b=https://iknow-pic.cdn.bcebos.com/7dd98d1001e93901b7176e426bec54e736d196b1?x-bce-process=image%2Fresize%2Cm_lfit%2Cw_600%2Ch_800%2Climit_1%2Fquality%2Cq_85%2Fformat%2Cf_auto)
4、在表设计界面,添加一个用来存储base64字符串的字段,base64Value,选择字段类型为 varchar(MAX),保存表设计。
![](https://video.ask-data.xyz/img.php?b=https://iknow-pic.cdn.bcebos.com/9c16fdfaaf51f3de1fa75a1884eef01f3a2979b1?x-bce-process=image%2Fresize%2Cm_lfit%2Cw_600%2Ch_800%2Climit_1%2Fquality%2Cq_85%2Fformat%2Cf_auto)
5、最后通过编写程序代码,将普通字符串以Base64编码方式存入数据库,就可以了。
![](https://video.ask-data.xyz/img.php?b=https://iknow-pic.cdn.bcebos.com/0823dd54564e92586f2165928c82d158ccbf4eb1?x-bce-process=image%2Fresize%2Cm_lfit%2Cw_600%2Ch_800%2Climit_1%2Fquality%2Cq_85%2Fformat%2Cf_auto)