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

问题描述

我正在使用 phpMyAdmin v3.4.10.1deb1 来管理我的 Ubuntu 服务器上的一些 MySQL 表，其中包含具有 SQL 格式TEXT"的字段.显示这些字段时，默认情况下它们会被截断.我总是必须单击符号←T→"才能将文本扩展到完整长度.但我不想在每个查询上都点击一次，因为这意味着每个查询都会执行两次.

我希望全文"是默认的.但是我没有找到设置这个的地方.

你能帮忙吗?

解决方案

这里有一个 hacky 解决方案(对我有用)但需要更改一些 PMA php 文件.如果你知道你在做什么，你可以试试这个:

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

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

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

请注意，我是在稍微不同的 PMA 版本 (3.5.2.2) 上测试的，因此函数/文件名可能不同.

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.

Can you help?

解决方案

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:

• 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.

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屋！