Unsupported Screen Size: The viewport size is too small for the theme to render properly.

Importing Csv With Accented

forums › forums › SQLyog › Using SQLyog › Importing Csv With Accented

  • This topic is empty.
Viewing 1 reply thread
  • Author
    Posts
    • August 5, 2009 at 11:41 am #11618
      moijisi
      Member

      How do I import a csv file with data accented?

      Instead of accents I get strange symbols.

    • August 5, 2009 at 12:15 pm #29427
      peterlaursen
      Participant

      1) Please confirm: are you using the LOAD DATA type of CSV-import

      2) How is the file encoded? Could you attached a small example? Or simply open in Notepad and next 'save as' and see what encoding Notepad proposes for the file. a unicode or a non-unicode encoding?

      3) Tell the SQLyog version you are using, the MySQL version and the default charset for this MySQL server.

      Since MySQL 5.0.37 there is a CHARSET parameter in LOAD data and we have supported that in SQLyog for at least 1 year. Before that the server will assume the the file is encoded like the server default charset (and the option will be 'greyed out' in SQLyog). That means for instance that with servers before that a utf8-file will not import to a server having latin1 as default charset (unless file is pure ASCII).

      See attached image for how to specify the charset for import in SQLyog:

      [attachment=1230:charset.jpg]

  • Author
    Posts
Viewing 1 reply thread
  • You must be logged in to reply to this topic.