如何设置“全文"?默认为phpMyAdmin? [英] How to set "full texts" as default for phpMyAdmin?

问题描述

我正在使用phpMyAdmin v3.4.10.1deb1来管理我的Ubuntu服务器上带有SQL格式"TEXT"字段的某些MySQL表.显示这些字段时，默认情况下会将其截断.我总是必须单击符号←T→"以将文本扩展到完整长度.但是我不想在每个查询上都单击此按钮，因为这意味着每个查询都要做两次.

I am using phpMyAdmin v3.4.10.1deb1 to manage some MySQL-Tables on my Ubuntu-Server with fields that have the SQL-format "TEXT". When those fields are displayed, they are truncated by default. I always have to click on the Symbol "←T→" to expand the texts to their full length. But I don't want to do this click on every single query, because this means, that every query hat do be done twice.

我希望默认为全文".但是我找不到在哪里设置它.

I want that "full texts" is default. But I don't find the place where to set this.

你能帮忙吗?

推荐答案

这是hacky解决方案(对我有用)，但需要更改一些PMA php文件.如果您知道自己在做什么，则可以尝试以下操作:

Here's the hacky solution (that works for me) but require changing some PMA php files. If you know what you're doing, you can try this:

• 在您的phpmyadmin文件夹中找到以下文件:phpmyadmin/libraries/display_tbl.lib.php
• 在此文件中找到名为PMA_displayTable_checkConfigParams
的函数
• 在此函数的开头添加以下行:

• in your phpmyadmin folder locate this file: phpmyadmin/libraries/display_tbl.lib.php
• in this file locate function called PMA_displayTable_checkConfigParams
• in the beginning of this function add the line below:

    if (!isset($_REQUEST['display_text'])) $_REQUEST['display_text'] = 'F';

默认情况下，这将启用全文"，允许您切换回部分文本"模式.

This would enable the "full text" by default allowing you to switch back to the "partial text" mode.

请注意，我在稍有不同的PMA版本(3.5.2.2)上进行了测试，因此功能/文件名可能有所不同.

Please mind that i was testing this on a slightly different PMA version (3.5.2.2), so the function/file names might be different.

这篇关于如何设置“全文"?默认为phpMyAdmin?的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！