Uploaded image for project: 'Other'
  1. Other
  2. OTHER-164

Can't enter certain strings.

    XMLWordPrintable

    Details

    • Type: Bug
    • Status: Closed
    • Priority: Normal
    • Resolution: Duplicate
    • Component/s: Forums
    • Labels:
      None

      Description

      Certain strings involving Unicode characters where the printed character length is less than 20 characters, but the byte length is more than 20 bytes, will not be accepted by the forums.

      For example:
      five→five→five→five→five→ works, because both lengths are more than 20
      five→five→five→five→ doesn't work because the string length is 20 but the byte length is 24.
      12345678901234567890 works, because both are exactly 20
      1234567890123456789" doesn't work, because the string length is 20 but the byte length is 21.

      The error is:
      Database reported: ERROR: value too long for type character varying(20) .

      Failed query: INSERT INTO search_words (word) VALUES('1234567890123456789"')

        Attachments

          Issue Links

            Activity

              People

              Assignee:
              Unassigned Unassigned
              Reporter:
              hawke Alex Mauer
              Votes:
              0 Vote for this issue
              Watchers:
              0 Start watching this issue

                Dates

                Created:
                Updated:
                Resolved:

                  Packages

                  Version Package