Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

Sign up for GitHub

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Jump to bottom

🐛 Bug: SingleLineText field silently drops part of text #7694

Open
1 task done
opokhvalit opened this issue Feb 22, 2024 · 1 comment · May be fixed by #8437
Open
1 task done

🐛 Bug: SingleLineText field silently drops part of text #7694

opokhvalit opened this issue Feb 22, 2024 · 1 comment · May be fixed by #8437
Assignees
@rohittp0
Labels
🐬 DB : MySQL Issue found in MySQL Status: Reproducible Able to reproduce the issue based on the reporters' guideline.

Comments

@opokhvalit
Copy link

Please confirm if bug report does NOT exist already ?

  • I confirm there is no existing issue for this

Steps to reproduce ?

The SingleLineText field silently drops part of text over some limit. For my case it drops all text over 45 symbols without any warning. And, unfortunately, any limits are not described in the documentation.
Mysql8 is used as backend DB with utf8 encoding

For reproduce:

  • create SingleTextLine field in the table
  • fill it by some text with lench over 45 symbols
  • save data
  • refresh page

Desired Behavior

  1. describe SingleLineText size limits (if any) in the documentation
  2. show error message, do not allow to save oversized text line

Project Details

Node: v18.18.2
Arch: x64
Platform: linux
Docker: true
RootDB: mysql2
PackageVersion: 0.204.0

Attachments

No response
@dstala dstala added 🐬 DB : MySQL Issue found in MySQL Status: Reproducible Able to reproduce the issue based on the reporters' guideline. labels Mar 30, 2024
@dstala
Copy link
Member

dstala commented May 7, 2024

@rohittp0

  • check the limit that we have in PG. if its easy to extend limit for single line text for mysql - let us do it.
  • and let us limit the input box after that many characters are filled in. user should not be able to add more & see that its dropped silently.

@rohittp0 rohittp0 linked a pull request May 9, 2024 that will close this issue
nc-fix/ SingleLineText Fields silently dropping larger than length values #8437
Open
7 tasks
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Assignees

@rohittp0 rohittp0

Labels
🐬 DB : MySQL Issue found in MySQL Status: Reproducible Able to reproduce the issue based on the reporters' guideline.
Projects
🚀 NocoDB: Issue Board
Status: 🏌️ Open
Milestone
No milestone
Development

Successfully merging a pull request may close this issue.

nc-fix/ SingleLineText Fields silently dropping larger than length values nocodb/nocodb
3 participants
@opokhvalit @rohittp0 @dstala