Home » SQL & PL/SQL » SQL & PL/SQL » Eliminate Special characters.
Eliminate Special characters. [message #230027] Tue, 10 April 2007 12:15 Go to next message
Messages: 83
Registered: October 2005
Location: chennai
I am working in logmnr.Our logminer procedure is getting data from archivelog files and inserting into logmnr table .

In the logminer table, Some special characters like á were added with data .
I dont know how this character came.

If i am quering the table ,It displays empty string.




BUT in the table , Data is stored like "áVEN".

Can anyone tell me how this special character is added ?

is there anyway to elimainate these invisible characters(á) ?

[Updated on: Tue, 10 April 2007 12:16]

Report message to a moderator

Re: Eliminate Special characters. [message #230044 is a reply to message #230027] Tue, 10 April 2007 13:25 Go to previous message
andrew again
Messages: 2577
Registered: March 2000
Senior Member
You need to examine the character to see what it is - never rely on what's being displayed. Your client NLS settings and client codepage capabilities can influence what you see.

select parameter, value, banner
  from v$nls_parameters a, v$version
  where parameter like '%CHARACTERSET%'
  and banner like 'PL/SQL Release%';

then dump the data in Hex or decimal to examine it...
select name, vsize(name), dump(name, 1010) Decimal_bytes, dump(name, 1016) Hex_Bytes from logmnr;
Previous Topic: srw.do_sql ora-01830 date picture ends ...
Next Topic: help with TRANSLATE function
Goto Forum:

Current Time: Tue Aug 22 15:43:08 CDT 2017

Total time taken to generate the page: 0.23868 seconds