Oracle Text will not work with NVARCHAR2. What else might be unavailable?
22
4
We are going to migrate an application to have it support Unicode and have to choose between unicode character set for the whole database, or unicode columns stored in N[VAR]CHAR2. We know that we will no more have the possibility of indexing column contents with Oracle Text if we choose NVARCHAR2, because Oracle Text can only index columns based on the CHAR type. Apart that, is it likely that other major differences arise when harvesting from Oracle possibilities? Also, is it likely that some new features are added in newer versions of Oracle, but only supporting either CHAR columns or NCHAR columns but not both? Thank you for your answers. Note following Justin's answer: Thank you for your answer. I will discuss your points, applied to our case: Our application is usually alone on the Oracl...