I loading some excel 1997-03 format file into oracle database but my data some certain special characters like R S&P R where R is nothing but Registered . I cant copy past same thing. This R is inside a circle.
But i'm getting like this ¿ S&P¿ after loading into DB.
Since its a excel 1997-03 format i dont have option to change to UTF-8 or other such code.
I dont want to trim this special characters rather i want it to be loaded as it is.
When i changed the data type to V_Wstring or WString, i'm getting only 1st character of data. So i'm using V_String.
How to achieve this?
