trouble in change attribute type from char to varchar2
Posted on 2002-06-06
I create a table in oracle 8i and insert many data.
create table item(item_id number,
Later on i changed the location_id from char(10) to varchar2(10)
using alter table modify(location_id varchar2(10))
But when i run the query
select item_id, location_id from item where location_id
I cannot select anything.
Actually there are many rows containing '114A' and it works fine before i make the change.
Please tell me what is wrong and how to fix it.