SQLite Forum

Nonsensical import column separator error
Login

Nonsensical import column separator error

(1) By anonymous on 2021-07-11 12:44:52 [link] [source]

    sqlite> .mode list
    sqlite> .separator ¿
    sqlite> .import filename tablename
    Error: multi-character column separators not allowed for import
    sqlite> 

'¿' is a single character, so I think you mean "multi-byte column separators" here.

(2) By Larry Brasfield (larrybr) on 2021-07-11 12:59:14 in reply to 1 [source]

You're right. This will be remedied soon.

(3) By anonymous on 2021-07-11 13:14:28 in reply to 2 [link] [source]

Don't forget to check for the same issue with row separators.