Skip to Main Content
Forums

SQL & PL/SQL

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Weird SQUARE BOXES in updated fields

784247Oct 1 2010 — edited Oct 1 2010
I updates few hundreds of records by multiple updte statements where i copied and inserted values.
I think I left some blank spaces .. i donno but ...
When i SELECT everything from what i updated I see some weird boxes (ONE SQUARE SHAPE BOX) next to the value
Ex: 234567'SQUARE BOX' ----> shape in place of 'SQUARE BOX'
Ex; AGIES'SQUARE BOX' -----> shape in place of 'SQUARE BOX'

But when i select and copy it and paste it into text pad it shows up as 234567 with cursor after few spaces
same is teh case with varchar field.

I tried RTRIM

but no use.

Please suggest
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Oct 29 2010
Added on Oct 1 2010
#pl, #sql
3 comments
1,446 views