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
venkatraghavan
Messages: 83
Registered: October 2005
Location: chennai
Member
Hi,
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.

EX:

SELECT NAME FROM logmnr;

NAME
-------------------
"VEN"

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: Temp table
Next Topic: Joins
Goto Forum:
  


Current Time: Sat Feb 15 15:02:08 CST 2025