Is there a configuration in TiDB to limit the display length of fields?

This topic has been translated from a Chinese forum by GPT and might contain errors.

Original topic: tidb是否有限制展示字段长度的配置

| username: Jjjjayson_zeng

[TiDB Usage Environment] Production Environment / Testing / Poc
[TiDB Version]
[Reproduction Path] What operations were performed when the issue occurred
[Encountered Issue: Issue Phenomenon and Impact]
[Resource Configuration] Go to TiDB Dashboard - Cluster Info - Hosts and take a screenshot of this page
[Attachment: Screenshot/Logs/Monitoring]

| username: 啦啦啦啦啦 | Original post link

Try adjusting the group_concat_max_len parameter.

| username: swino | Original post link

For the field length limit configuration of TiDB, it is mainly controlled by the tidb_build_config command line parameter of the TiDB Server. This parameter includes two default values: OneByOne and BatchInsert, and is configured in OneByOne mode.

| username: 芮芮是产品 | Original post link

His truncation is a Windows window software.

| username: Hacker007 | Original post link

There is no limit. Is this a tool issue? However, there is a 6M limit for a single row of data.

| username: hey-hoho | Original post link

It looks like Navicat. The database definitely won’t truncate, and I don’t think the tool will either. It seems more likely that the data was like this when it went in.

| username: zxgaa | Original post link

You can directly log in and check on the server. TiDB should not have this limitation.

| username: Kongdom | Original post link

Try using a different tool. Also, do you want to restrict it or not?

| username: dba远航 | Original post link

There is a length limit for this combination, I encountered it before in Oracle.

| username: heiwandou | Original post link

There are limitations, even at the maximum it can’t be the same as a large field. It seems that there hasn’t been any field overflow yet.

| username: 随缘天空 | Original post link

It seems there isn’t one. Can’t you use a string truncation function to limit the display to a certain number of characters?

| username: oceanzhang | Original post link

Yes, there is, but I forgot which one specifically.

| username: TiDBer_小阿飞 | Original post link

Isn’t this displayed by the tool you’re using? Go check the backend and see.

| username: system | Original post link

This topic was automatically closed 60 days after the last reply. New replies are no longer allowed.