Varchar fields not truncating

Collapse
X
 
  • Time
  • Show
Clear All
new posts
  • zaisaipai
    Junior Member
    • Jan 2018
    • 7

    Varchar fields not truncating

    Is it intentional that text entered in varchar field is not saved at all when the text is more than 255 chars? (instead of truncating the rest)
    Same question with import - when I have to import records with varchar fields then the whole record will be not imported when any of the imported varchar fields is over 255 chars in csv.
    Maybe it would be sensible to show a warning and truncate the field instead of not saving/not importing the record.
  • yuri
    Member
    • Mar 2014
    • 8440

    #2
    Yes. It's intentional. It's better to throw an error rather than truncate to avoid losing data. Regarding the import it might be reasonable to inform a user somehow. Unfortunately, at this moment I have very lot of work to do so can't address this in the nearest future.
    If you find EspoCRM good, we would greatly appreciate if you could give the project a star on GitHub. We believe our work truly deserves more recognition. Thanks.

    Comment

    • zaisaipai
      Junior Member
      • Jan 2018
      • 7

      #3
      Update: In a csv dataset of ca 400 records 19 records had a text field longer than 255 chars. 17 of them were imported AND TRUNCATED. 2 were silently ignored (not only the field but whole record).
      Of these two only one looked a little bit suspicious - contained a lot of strange quotes. (import delimiter is a tab). The other one was absolutely normal text. I am still confused...

      Comment

      • yuri
        Member
        • Mar 2014
        • 8440

        #4
        There should be something in the log file.
        If you find EspoCRM good, we would greatly appreciate if you could give the project a star on GitHub. We believe our work truly deserves more recognition. Thanks.

        Comment

        Working...