Eliminate Special characters. [message #230027] |
Tue, 10 April 2007 12:15  |
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  |
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;
|
|
|