Home » SQL & PL/SQL » SQL & PL/SQL » Handling trademark special character during data loading in Oracle 11g (merged 5) (Oracle 11g, Unix)
Handling trademark special character during data loading in Oracle 11g (merged 5) [message #562913] Mon, 06 August 2012 15:59 Go to next message
sanjoyp158
Messages: 19
Registered: June 2007
Junior Member
Hi,

we have a Oracle 11g database, but it does not support UTF8 character set. Now we have received a file which contains records with Trade Mark symbol (special character). Now when we are trying to load the record, it is getting loaded with a sign "?". As a result when we try to display record in web application, the application is not able to show the records properly.

Please let me how I can fix this issue.

Thanks,
Sanjoy
Re: Handling trademark special character during data loading in Oracle 11g [message #562919 is a reply to message #562913] Mon, 06 August 2012 17:02 Go to previous messageGo to next message
sanjoyp158
Messages: 19
Registered: June 2007
Junior Member
One more addition, the database supports character set WE8ISO8859P1
Re: Handling trademark special character during data loading in Oracle 11g [message #562923 is a reply to message #562919] Mon, 06 August 2012 18:11 Go to previous messageGo to next message
BeefStu
Messages: 192
Registered: October 2011
Senior Member
I have the same issue.. YOU may want to follow this thread character translation
Re: Handling trademark special character during data loading in Oracle 11g [message #562933 is a reply to message #562919] Tue, 07 August 2012 01:04 Go to previous messageGo to next message
Michel Cadot
Messages: 59427
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
The problem is NOT in the database but in the client settings.
Check your NLS_LANG setting, check what your client program supports.
The topic BeefStu mentioned is there.

Regards
Michel
Re: Handling trademark special character during data loading in Oracle 11g [message #563098 is a reply to message #562933] Wed, 08 August 2012 09:32 Go to previous messageGo to next message
sanjoyp158
Messages: 19
Registered: June 2007
Junior Member
Hi Michel,

We can not change the NLS setting as per the business requirement.

Can you please help me to handle the situation in other way ?

Thanks,
Sanjoy
Re: Handling trademark special character during data loading in Oracle 11g [message #563101 is a reply to message #563098] Wed, 08 August 2012 11:24 Go to previous message
Michel Cadot
Messages: 59427
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
So you have a big problem.
You tell Oracle something that is wrong so, as the proverb says, garbage in garbage out.

Regards
Michel
Previous Topic: Update Table After Insert to another Table
Next Topic: Need to give Grant to Schema of Different Versions of Oracle Databases
Goto Forum:
  


Current Time: Sat Oct 25 16:32:47 CDT 2014

Total time taken to generate the page: 0.09534 seconds