Forum Discussion

Swoop's avatar
Swoop
Frequent Contributor
13 years ago

BUG: Curly braces in description column cause SQL error on import

While trying to import a csv file, which contains curly braces, I get a SQL error encountered during a csv import.



However, in other cases, I've seen the import actually work.  It seems the import is converting curly braces.

{ gets converted to single-quote followed by a space followed by a plus-sign followed by a space

} gets converted to a space followed by a plus-sign followed by a space followed by a single-quote
  • Swoop's avatar
    Swoop
    Frequent Contributor
    Support replied:

    That is correct, curly brackets are known to cause a problem. I would suggest using square brackets instead as a workaround.
  • Swoop's avatar
    Swoop
    Frequent Contributor
    I confirmed, replacing curly braces with square brackets, as support suggested, resolves the issue.