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?
Hi @Jean-Balteryx ,
Here it is a sample file which has a special character in fund name.
I want same thing to be loaded in output.
I get the following results importing the file, is that what you look for ?
Cheers,
Jean-Baptiste
Yes.
Its coming in alteryx output but the same is not going into Oracle DB. The special characters is coming as inverted question mark ¿
Unfortunately I won't be able to test in oracle ! 😕
I just wanted to know what could be the problem in a database.
because from alteryx side everything is fine but the moment i'm loading into oracle it got truncated.
It may be the data type set into the DB. Have you checked ?
In DB its VARCHAR2(255)
I suspect it might due to the collation of your database/ table.
I've found this article in fixing the garbled character in the database - do you want to take a quick look and see if it's relevant?
https://jonisalonen.com/2012/fixing-doubly-utf-8-encoded-text-in-mysql/