How to distinguish VARCHAR2 vs NVARCHAR2

jdorlon · Post by **jdorlon** » Wed 30 Jul 2008 14:37

Hello,

When I run a query in a TSmartQuery, how can I tell if a ftString field is VARCHAR2 or NVARCHAR2? Is this possible? Querying dba_tab_columns is not an option for me.

Thanks.

-John

Plash · Post by **Plash** » Thu 31 Jul 2008 08:16

You can check the SubDataType property of TOraFieldDesc. It equals to dtNString (or dtNWideString when UseUnicode = True) for NVARCHAR2 fields.

Code: Select all

SmartQuery.GetFieldDesc('FIELD1').SubDataType

jdorlon · Post by **jdorlon** » Thu 31 Jul 2008 14:34

Thank you, it works.