Apply OS: Windows, macOS, Linux

Apply Navicat Product: Navicat for MySQL, Navicat for PostgreSQL, Navicat for Oracle, Navicat for SQL Server, Navicat for SQLite, Navicat for MariaDB, Navicat Premium

Apply Navicat Version No.: Version 11.2 or below

 

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 [WIDEMEMO].

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, [WIDEMEMO] will be displayed.

 

macOS

Users just need to click on Text or Hex button for once. The bottom window will not disappear even you switched to other columns.

In Navicat Preferences window, you can enable to display text value in data grid instead of showing [TEXT].

Steps:

1. In Navicat main menu, Choose Navicat xxx > Preferences.
2. Under Grids tab, enable Default show text to show actual data in TINY TEXT, MEDIUM TEXT, TEXT and LONG TEXT fields. Otherwise, [TEXT] will be displayed.