为提高效率,提问时请提供以下信息,问题描述清晰可优先响应。
【DM版本】: dm8_20230808_rev197096_x86_rh6_64
【操作系统】:linux
【CPU】:
【问题描述】*:
如截图所示,表中字段为varchar类型,insert语句
INSERT INTO "OpenPlatform"."configitem_cfe13440" (_jsonb) VALUES ('{"$s":{"p":{"_id":{"t":"objectId"},"agency":{"t":"object","$s":{"p":{"_id":{"t":"string"},"name":{"t":"string"}},"$k":["_id","name"]}},"itemID":{"t":"string"},"groupID":{"t":"string"},"moduleID":{"t":"string"},"itemField":{"t":"string"},"itemType":{"t":"string"},"itemDescribe":{"t":"string"},"itemValue":{"t":"object","$s":{"p":{"pro":{"t":"string"},"pre":{"t":"string"},"test":{"t":"string"},"dev":{"t":"string"}},"$k":["pro","pre","test","dev"]}},"createTime":{"t":"date"},"createUser":{"t":"object","$s":{"p":{"_id":{"t":"string"},"username":{"t":"string"}},"$k":["_id","username"]}},"updateUser":{"t":"object","$s":{"p":{"_id":{"t":"string"},"username":{"t":"string"}},"$k":["_id","username"]}},"lastUpdateTime":{"t":"date"}},"$k":["_id","agency","itemID","groupID","moduleID","itemField","itemType","itemDescribe","itemValue","createTime","createUser","updateUser","lastUpdateTime"]},"_id":"657bc61d941692ea8fb85e85","agency":{"_id":"","name":"默认机构"},"itemID":"51b81da9-394f-4454-9655-e59ce301b351","groupID":"default_rio_config_group","moduleID":"appmgnt03","itemField":"GlobalPluginConfigTemplate","itemType":"string","itemDescribe":"","itemValue":{"pro":"let buildPlugin = rf.Plugin.buildPlugin(%v, '%v');\n","pre":"","test":"","dev":""},"createTime":1702610461396,"createUser":{"_id":"1d985beb-b975-4abe-923e-8cac2c53a3a2","username":"admin"},"updateUser":{"_id":"1d985beb-b975-4abe-923e-8cac2c53a3a2","username":"admin"},"lastUpdateTime":1702610461396}');
ps:我看varchar最大长度是8188,可能我的数据会大于这个长度,像这种存储json类型的数据,DM建议使用什么方式进行存储
varchar的精度可以定义为32767,但是实际存储长度受页大小影响,只能是页大小的一半,如果不够存储,可以用TEXT去存储。
插入问题已解决。
帮忙看一下
ps:我看varchar最大长度是8188,可能我的数据会大于这个长度,像这种存储json类型的数据,DM建议使用什么方式进行存储