How to Change Oracle Data Storage Type

jhiatt09

I'm hoping to use the VARCHAR2 column storage type in Oracle rather than NVARCHAR2, which appears to be the default storage type used by Dataiku for strings in Dataiku-managed datasets stored in Oracle. What's the best way to do this?

pmasiphelps

Hi,

As a one-off workaround, in your output dataset (stored in Oracle), go to Settings -> Advanced -> Table creation mode -> Manually define

You can then manually change the column storage types in this field.

You can find/replace all instances of "NVARCHAR2" with "VARCHAR2" by:

1. Type "CTRL + OPTION + F" in your keyboard. A find/replace box will pop up. Enter "NVARCHAR2" here, then hit the enter key:

   

2. Write "VARCHAR2" in the "with" field, then hit the enter key:

   

3. Then choose replace "All":

   

Now your dataset should have column data types of "VARCHAR2".

Best,

Pat

Clément_Stenac

Hi,

It's not possible to change this. We use NVARCHAR2 since it can accomodate all characters, which is not the case of VARCHAR or VARCHAR2.

We'd be interested in hearing more about your use case for using VARCHAR2.