Home » SQL & PL/SQL » SQL & PL/SQL » problem identifying a symbol in the content of a column
problem identifying a symbol in the content of a column [message #340490] Wed, 13 August 2008 01:56 Go to next message
kirtani
Messages: 8
Registered: August 2008
Junior Member
attached TXT file is the content of a column .I am getting some square symbol in the data attached.what does it represent.How can I read it.The data type of this is column is long.
Re: problem identifying a symbol in the content of a column [message #340506 is a reply to message #340490] Wed, 13 August 2008 02:36 Go to previous messageGo to next message
Michel Cadot
Messages: 68733
Registered: March 2007
Location: Saint-Maur, France, https...
Senior Member
Account Moderator
They are non printable characters.

Regards
Michel
Re: problem identifying a symbol in the content of a column [message #340514 is a reply to message #340506] Wed, 13 August 2008 02:56 Go to previous messageGo to next message
misragopal
Messages: 125
Registered: June 2005
Location: New Delhi, india
Senior Member

in continuation to previous line, there are two types of characters are used.
if we put these two characters in 'ascii', will give its chr value. Like-

select ascii ('') a, ascii('
') from dual


as result first char's ascii vale is 4 and another is 10. Char value 10 means
it is line change character. while Ascii value 4 will be some character in
Swedish(guess as google says).


Re: problem identifying a symbol in the content of a column [message #340517 is a reply to message #340506] Wed, 13 August 2008 03:04 Go to previous messageGo to next message
kirtani
Messages: 8
Registered: August 2008
Junior Member
At the front hand too i cant find any special character.Attached is the data displayed at front hand.

Regards,
Jaya
Re: problem identifying a symbol in the content of a column [message #340532 is a reply to message #340517] Wed, 13 August 2008 03:45 Go to previous message
Michel Cadot
Messages: 68733
Registered: March 2007
Location: Saint-Maur, France, https...
Senior Member
Account Moderator
Then your transfer from front to back end is wrong.

Regards
Michel
Previous Topic: Help with "What If" analysis
Next Topic: Partition Table
Goto Forum:
  


Current Time: Mon Feb 10 04:01:13 CST 2025