Hello,
I have oracle database with db. character set EE8MSWIN1250, national character set AL16UTF16. Delphi is XE2.
When I create nvarchar2 field and try to store there unicode text with TOracleQuery with INSERT statement, then data are not stored correctly.
Problem is when TOracleQuery.DeclareVariable is called - on the end of this procedure is call to DeclareVariableCharSet .... with charsetform ocfDatabase.
When I call manually
fQuery.DeclareVariableCharSet(AName, ocfNational, fQuery.Session.CurrentNCharSetID);
then query work as expected. Does it mean, that I need to take control of calling DeclareVariableCharSet on nchar/nvarchar2 database fields? Is it not possible to do it automatically similar to SQL select statement, where CharSetForm and ChareSetID are detected automatically during query describe?