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

Connect CSV file sep_char option

    XMLWordPrintable

Details

    Description

      Hi,

      I have a file with separators "(#]" I need to load it ,using CONNECT engine:

      name.csv

      		 
      Name(#]birth(#]children
      		 
      "Archibald"(#]17/05/01(#]3
      		 
      "Nabucho"(#]12/08/03(#]2


      create table people (
      		 
        name char(12) not null,
      		 
        birth date not null date_format='DD/MM/YY',
      		 
        children smallint(2) not null)
      		 
      engine=CONNECT table_type=CSV file_name='C:\\MariaDB\\data\\name.csv'
      		 
      header=1 sep_char='(#]' quoted=1;

      It gives :

      Erreur SQL (1296) : Got error 122 'Field 2 too long for birth line 1 of C:\MariaDB\data\name.csv' from CONNECT */

      Is there any way to load this kind of file?

      Thanks for help.

      Regards

      Attachments

        Activity

          People

            bertrandop Olivier Bertrand
            Mariabti Btissam
            Votes:
            0 Vote for this issue
            Watchers:
            4 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.