Special Characters in a .csv

(2 posts) (2 voices)

Tags:

No tags yet.

  1. Aardvark, Member

    Hello,

    I'm having difficulty when processing customer addresses into a report.

    We're using a automated process to download the users addresses to a csv. Upload them to mydbr (so they land in the server side files) and then a report is working with the addresses and bringing them into our database.

    The problem I'm encountering is mydbr is struggling to read those special characters.

    For example they're on the .csv file as 'á' but when I open the .csv in the server side files it appears as '�' (a black box with a question mark in it)

    When my report gets to lines with a special character it errors stating the following:

    'DB error (1064): You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '()' at line 1 SQL call ();'

    However this only happens on lines with special characters.

    Are there any suggestions/fixes for this?

    Best regards

    Chris

  2. myDBR Team, Key Master

    Sounds like your CSV file's charset is ISO-8859-1 (Latin 1). myDBR's default character set is UTF-8. Try the import with the following option:

    select 'dbr.import.options', 'charset', 'ISO-8859-1';

    This will tell myDBR to read the data as Latin 1 and myDBR converts it to UTF-8 internally.

    --
    myDBR Team


Reply

You must log in to post.