最近程序需要一个longtext字段存储大量的文字,用navicat编辑的时候longtext字段显示为“Memo”,并且无法编辑。上网查了查,找到了navicat的官网,上面对这个问题是这样描述的:
Why does Navicat only display MEMO in data grid? How can I see the actual text?
From Navicat Wiki
Jump to: navigation, search
Apply OS : Windows, Mac, Linux
Apply Navicat Product : All
Apply Navicat Version No. : All
Windows & Linux
Navicat provides Text Viewer and Editor to view and edit TEXT fields content. The editor allows you to view, update, insert, or delete data in a table.
1.Users just need to click on Memo or Hex button for once. The bottom Window will not disappear even you switched to other columns.
2.In Table View window, select View and enable Show Memo In Grid.
In Navicat Option Window, you can enable to display text value in data grid instead of showing [Memo].
解决办法为:
Steps :
1.In Navicat main window, Choose Tools > Options.
2.Under Appearance > Data & Grid, enable Show TEXT BLOB fields in data grids to show actual data in TINY TEXT, MEDIUM TEXT, TEXT and LONG TEXT fields. Otherwise, [Memo] will be displayed.
如果你用的是中文版顺序就是 工具–选项–资料表–选中 在数据表网络中显示文字Blob字段,确定就OK.
参考:http://wiki.navicat.com/wiki/index.php/Why_does_Navicat_only_display_MEMO_in_data_grid%3F_How_can_I_see_the_actual_text%3F