Re: [sqlite] [BUG] shell: .import: no special characters in table name

[Clemens Ladisch]

Clemens Ladisch wrote:
> Simon Slavin wrote:
>> On 19 Oct 2017, at 7:38pm, Clemens Ladisch wrote:
>>> the .import command does not work (and can show misleading error messages)
>>> if the table name contains special characters:
>>>
>>>  sqlite> .import test.csv temp.t
>>
>> What format is the file "temp.t" in ?  UTF-8 ?  ASCII ?  Some sort of code 
>> page ?
>
> The contents of the file do not matter; just use ".once test.csv", "select 
> 'x';".

Sorry, I misread; "test.csv" is the file name, "temp.t" is the table name.


Regards,
Clemens
___
sqlite-users mailing list
sqlite-users@mailinglists.sqlite.org
http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] [BUG] shell: .import: no special characters in table name

[Clemens Ladisch]

Simon Slavin wrote:
> On 19 Oct 2017, at 7:38pm, Clemens Ladisch wrote:
>> the .import command does not work (and can show misleading error messages)
>> if the table name contains special characters:
>>
>>  sqlite> .import test.csv temp.t
>
> What format is the file "temp.t" in ?  UTF-8 ?  ASCII ?  Some sort of code 
> page ?

The contents of the file do not matter; just use ".once test.csv", "select 
'x';".


Regards,
Clemens
___
sqlite-users mailing list
sqlite-users@mailinglists.sqlite.org
http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] [BUG] shell: .import: no special characters in table name

[Simon Slavin]

On 19 Oct 2017, at 7:38pm, Clemens Ladisch  wrote:

> the .import command does not work (and can show misleading error messages)
> if the table name contains special characters:
> 
>  sqlite> .import test.csv temp.t

What format is the file "temp.t" in ?  UTF-8 ?  ASCII ?  Some sort of code page 
?

Simon.
___
sqlite-users mailing list
sqlite-users@mailinglists.sqlite.org
http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users