This content has been marked as final. Show 6 replies
Doesn't look to me like junk ... looks like a character set issue. Run this query and post the results:
I doubt what you see as a "-" is really what you think it is.
SELECT dump(<column_name>) FROM <your_table>;
Include also your full version number and database NLS character set.
You may get this because you have a wrong NLS_LANG setting on the client: http://www.oracle.com/technetwork/products/globalization/nls-lang-099431.html#_Toc110410564.
To make sure you have correct character code point stored in database use SQL DUMP function: http://www.oracle.com/technetwork/products/globalization/nls-lang-099431.html#_Toc110410561.
Typ=1 Len=25: 67,117,115,116,111,109,101,114,32,67,104,97,110,103,101,32,150,32,72,97,110,100,111,102,102
oracle version is 22.214.171.124.0
NLS_CHARACTERSET is WE8MSWIN1252
did you check OS Language Settings , Did you check character supported
Which Character Set Supports Which Language [ID 62421.1]
How hypen ( - ) converted to turned question mark (¿)
The Ascii character 150 turns to 192
Edited by: 986126 on 6 Feb, 2013 4:38 AM
Pl post exact OS and database versions, along with the database characterset, and exactly how (what tool etc) you are inserting this data into the database.