Oracle NVARCHAR type and "Data Frame Type Mapping"

[cjbj]

Discussed in #504

^{Originally posted by DATA2PLAYvf June 13, 2025}
Hello,

I saw the new functionality "Data Frame Type Mapping". The documentation mention that oracledb.DB_TYPE_NVARCHAR have no mapping with Arrow.
In my cases, all my datasets have this type. Bad luck !

Is it a limit due to arrow ? Is it an oracledb limitation that will be considered soon ?

Thanks !

Vincent

[anthony-tuininga]

I have pushed a patch that should add this support and have initated a build from which you can download pre-built development wheels once it completes. You can also build from source if you prefer. If you can test your scenario and confirm the patch works as expected, that would be appreciated!

[DATA2PLAYvf]

Yes, it works , and the gain in RAM consumption and duration with odf is amazing !!

Can you confirm that infer_schema_length= is no longer needed, I think that odf has all real properties.

Thanks, and thanks again ;-)

[anthony-tuininga]

You're very welcome! I am not familiar with infer_schema_length but perhaps @aosingh might know.