Home » SQL & PL/SQL » SQL & PL/SQL » checkbox charachter (oracle 11gr2)
checkbox charachter [message #674982] Thu, 28 February 2019 08:08 Go to next message
guddu_12
Messages: 227
Registered: April 2012
Location: UK
Senior Member
Dear Gurus

I am loading data from xml file into oracle and a special character checkbox symbol is getting converted into other character.
How can I preserve the checkbox character in the oracle data base.

Re: checkbox charachter [message #674983 is a reply to message #674982] Thu, 28 February 2019 08:33 Go to previous messageGo to next message
BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal
Senior Member
guddu_12 wrote on Thu, 28 February 2019 06:08
Dear Gurus

I am loading data from xml file into oracle and a special character checkbox symbol is getting converted into other character.
How can I preserve the checkbox character in the oracle data base.

REALLY?

We have ZERO idea what you have or what you do.

What exactly is "checkbox" character?

How can we reproduce what you report?

Please read and follow the forum guidelines, to enable us to help you:
OraFAQ Forum Guide
How to use {code} tags and make your code easier to read
Re: checkbox charachter [message #674984 is a reply to message #674983] Thu, 28 February 2019 09:20 Go to previous messageGo to next message
guddu_12
Messages: 227
Registered: April 2012
Location: UK
Senior Member
Libraries\Pictures

Hello Guys,

Checkbox character is the one we come across normal life where we have option to select multiple object on any website , Extracted the data from file just to show you how it comes in XML and get converted into oracle in different data . Take a look at data tag below

- <query>
  <author>XXXX</author> 
  <data>☐ T&D Control ☑ CE Twitter ☑ Connect Broadcast ☐ Connect Text ☐ 19 Recording ☐ ESUB ☐ ICS ☐ Pager Message ☐ NRCC Advised? More information will be produced soon.</data> 
  <name>Information</name> 
  <timeAdded>2018-03-10T08:22:05.981983Z</timeAdded> 
  </query>

Re: checkbox charachter [message #674985 is a reply to message #674984] Thu, 28 February 2019 09:40 Go to previous messageGo to next message
BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal
Senior Member
Consider to step back a second to better understand true source of the problem.
Can you do simple & basic test to manually INSERT string above into the Oracle database & successfully retrieve it using SELECT?
Simply put does your database character set support the checkbox character properly?
Please post whole session that shows actual SQL code & results showing how your database handles checkbox character.
Re: checkbox charachter [message #674986 is a reply to message #674982] Thu, 28 February 2019 09:45 Go to previous messageGo to next message
flyboy
Messages: 1903
Registered: November 2006
Senior Member
Just make sure character set in which are these special characters stored is specified before calling the process performing "loading data from xml file into oracle" (you are aware we know nothing about it). This process has to be able to recognize this value.
https://www.fileformat.info/info/unicode/char/2610/index.htm
https://www.fileformat.info/info/unicode/char/2611/index.htm
https://www.fileformat.info/info/unicode/char/2612/index.htm
I use system variable NLS_LANG for its specification when invoking data load from sqlplus. As I know nothing about your process, I cannot comment the way used for this identification and the value specifying input character set (after storing your post, it is coded in UTF-8; hard to confirm the original coding though).
Re: checkbox charachter [message #674987 is a reply to message #674982] Thu, 28 February 2019 10:43 Go to previous messageGo to next message
Michel Cadot
Messages: 68625
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator

Why didn't you feedback and thank people who spent time to help you in your previous topics?

Re: checkbox charachter [message #674993 is a reply to message #674987] Fri, 01 March 2019 03:59 Go to previous messageGo to next message
guddu_12
Messages: 227
Registered: April 2012
Location: UK
Senior Member
Hello Michel ,

I am not so bad to appreceiate for the help, I didn't check post as I was away form office. I will try the link give above and post you the finding
Re: checkbox charachter [message #675008 is a reply to message #674993] Fri, 01 March 2019 09:06 Go to previous message
BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal
Senior Member
Please post whole session that shows actual SQL code & results showing how your database handles checkbox character.
Previous Topic: How to denormalize multiple records into 1 row-
Next Topic: Binary Integer Division
Goto Forum:
  


Current Time: Fri Mar 29 02:01:33 CDT 2024