var sidebar_align = 'right';
var content_container_margin = parseInt('290px');
var sidebar_width = parseInt('270px');
Unanswered: Converting from NVARCHAR2 to VARCHAR2
Looking at the cast charts, it appears that the only way to convert between these two is to CAST to RAW then CAST to VARCHAR2. However, anything with a string of text ultimately fails.
So what is the recommended process for doing this type of conversion .. and doing it within an Oracle SELECT statement?
I don't think a simple CAST can help you - you will need to convert character data from one codeset to another. Look at the CONVERT() function.
Well I finally found a very simple solution:
to_char( field )
That did it for me.
Tags for this Thread