Load special characters as it is

[AnandKumar1]

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?

[Jean-Balteryx]

Hi @AnandKumar1 ,

Could you provide a sample file of data ?

Cheers,

Jean-Baptiste

[AnandKumar1]

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.

[Jean-Balteryx]

I get the following results importing the file, is that what you look for ?

Cheers,

Jean-Baptiste

[AnandKumar1]

Yes.

Its coming in alteryx output but the same is not going into Oracle DB. The special characters is coming as inverted question mark ¿

[Jean-Balteryx]

Unfortunately I won't be able to test in oracle ! 😕

[AnandKumar1]

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.

[Jean-Balteryx]

It may be the data type set into the DB. Have you checked ?

[AnandKumar1]

In DB its VARCHAR2(255)

[seinchyiwoo]

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/