Github user ijokarumawak commented on the issue:

    https://github.com/apache/nifi/pull/2145
  
    Added followings:
    
    - CLOB and NCLOB support to PutSQL
    - NCLOB support to ExecuteSQL
    
    Confirmed it can insert and select CLOB and NCLOB columns. For NCLOB, I've 
tested Japanese characters are inserted and retrieved successfully.
    
    A template is available here in Gist:
    https://gist.github.com/ijokarumawak/451085b01349c7e6e83bcc42182ecffc
    
    ```
    CREATE TABLE clob_test (
      i INT not null,
      c CLOB,
      nc NCLOB,
      CONSTRAINT clob_test_pk PRIMARY KEY (i)
    );
    ```


---

Reply via email to