Encoding problems

[joelcc]

Is it happening on a specific row of data? What encoding is the data base using for storage?

Yes.   It is only on a specific row.   (I notice when someone copies data from Microsoft Word with the an ' it will throw the error).

Using 

SELECT *
  FROM v$nls_parameters
 WHERE parameter LIKE '%CHARACTERSET';

I see that the Oracle Database encoding is set to WE8MSWIN1252

I also see see that the field that is holding the data is CLOB

I am using the devart Oracle dbx driver with the following settings (but that probably does not make up the difference.)

ClobAswideMemo := true
UnicodeEnvironment := true
UseUnicode := true

I can not change the Characterset on the the database but I might be able to change the CLOB to an NCLOB at the field level.

Do you think that would fix the issue?