Using query with a CSV file

Viewing 4 replies - 1 through 4 (of 4 total)
  • Plugin Author Meitar

    (@meitar)

    10 years, 6 months ago

    Are any of your columns labelled A, B, or C?

    Thread Starter micheldesrochers

    (@micheldesrochers)

    10 years, 6 months ago

    No. My columns have different names (DAY, DATE, etc.). But I tried both with their actual names (select DAY, DATE,…) and with A, B, C.

    Thread Starter micheldesrochers

    (@micheldesrochers)

    10 years, 6 months ago

    I found what looks like the source of the problem. It’s not working with encoding Unicode or UTF-8, but it works with ANSI. My file can contain French characters with accents. What encoding will work for me then?

    Plugin Author Meitar

    (@meitar)

    10 years, 6 months ago

    No. My columns have different names (DAY, DATE, etc.). But I tried both with their actual names (select DAY, DATE,…) and with A, B, C.

    I don’t think character encoding should be a problem. I do think your column names need to be enclosed in backticks; read the friendly manual.

    You probably want something like this:

    select `DAY`

    That said, it’s pretty hard to troubleshoot in the blind. Right above the button you pressed to post these messages, there’s a question:

    Did you include a link to your site, so that others can see the problem?

Viewing 4 replies - 1 through 4 (of 4 total)

The topic ‘Using query with a CSV file’ is closed to new replies.