OraFAQ Forum: SQL & PL/SQL » checkbox charachter

Home » SQL & PL/SQL » SQL & PL/SQL » checkbox charachter (oracle 11gr2)

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

checkbox charachter [message #674982]

Thu, 28 February 2019 08:08

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.

Report message to a moderator

Re: checkbox charachter [message #674983 is a reply to message #674982]

Thu, 28 February 2019 08:33

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

Report message to a moderator

Re: checkbox charachter [message #674984 is a reply to message #674983]

Thu, 28 February 2019 09:20

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>

Report message to a moderator

Re: checkbox charachter [message #674985 is a reply to message #674984]

Thu, 28 February 2019 09:40

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.

Report message to a moderator

Re: checkbox charachter [message #674986 is a reply to message #674982]

Thu, 28 February 2019 09:45

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).

Report message to a moderator

Re: checkbox charachter [message #674987 is a reply to message #674982]

Thu, 28 February 2019 10:43

Michel Cadot
Messages: 68785
Registered: March 2007
Location: Saint-Maur, France, https...

Senior Member
Account Moderator

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

Report message to a moderator

Re: checkbox charachter [message #674993 is a reply to message #674987]

Fri, 01 March 2019 03:59

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

Report message to a moderator

Re: checkbox charachter [message #675008 is a reply to message #674993]

Fri, 01 March 2019 09:06

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.

Report message to a moderator

Previous Topic:	How to denormalize multiple records into 1 row-
Next Topic:	Binary Integer Division

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Mon Sep 21 11:36:57 CDT 2026