Uploaded image for project: 'MariaDB Server'
  1. MariaDB Server
  2. MDEV-5057

Importing number from CSV, scientific notation with comma instead of period doesn't work

    XMLWordPrintable

Details

    • Bug
    • Status: Closed (View Workflow)
    • Minor
    • Resolution: Not a Bug
    • 5.5.32-galera
    • None
    • None
    • None
    • Windows, working with HeidiSQL

    Description

      I'm importing millions of numbers into a database using:

      LOAD DATA LOCAL INFILE 'filename'
      INTO Table 'tablename'
      Fields terminated by ';'
      Lines terminated by '\r';

      The numbers are mostly formatted like: 8,70840419842013E-03.
      I am importing into a 'FLOAT not null' field. The database converts the input to '8' instead of '0.00870840419842013'.

      New to MariaDB (and creating issues on this board) so please be gentle or give me tips on how to improve this issue. If this should be filed differently, please let me know.

      Attachments

        Activity

          People

            serg Sergei Golubchik
            ajcmulder Christiaan Mulder
            Votes:
            0 Vote for this issue
            Watchers:
            2 Start watching this issue

            Dates

              Created:
              Updated:
              Resolved:

              Git Integration

                Error rendering 'com.xiplink.jira.git.jira_git_plugin:git-issue-webpanel'. Please contact your Jira administrators.