<div>
Maybe the reason is the difference between the CHAR and VARCHAR2 datatypes - the length of a CHAR(10) field is always 10, while the length of the VARCHAR2(10) field is the real length of the stored string - in your case ('114A') it would be 4.<br />
So probably when your converted the datatype to VARCHAR2 all the strings got rightpadded with spaces.<br />
If you are sure that your data doesn't contain trailing spaces you might try the following statement:<br />
UPDATE item<br />
SET location_id = RTRIM(location_id);<br />
<br />
Then try to run your query again.<br />
Hope that helps!
</div>


Maybe the reason is the difference between the CHAR and VARCHAR2 datatypes - the length of a CHAR(10) field is always 10, while the length of the VARCHAR2(10) field is the real length of the stored string - in your case ('114A') it would be 4.
So probably when your converted the datatype to VARCHAR2 all the strings got rightpadded with spaces.
If you are sure that your data doesn't contain trailing spaces you might try the following statement:
UPDATE item
SET location_id = RTRIM(location_id);

Then try to run your query again.
Hope that helps!

<div>
<div class="content wysiwyg-content">
I create a table in oracle 8i and insert many data. <br />
<br />
create table item(item_id number,<br />
&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;location_id char(10));<br />
<br />
Later on i changed the location_id from char(10) to varchar2(10)<br />
<br />
using alter table modify(location_id varchar2(10))<br />
<br />
But when i run the query<br />
<br />
select item_id, location_id from item where location_id<br />
= '114A';<br />
<br />
I cannot select anything.<br />
<br />
Actually there are many rows containing '114A' and it works fine before i make the change.<br />
<br />
Please tell me what is wrong and how to fix it.<br />
Thank you.<br />
<br />

</div>
</div>


I create a table in oracle 8i and insert many data. 

create table item(item_id number,
             location_id char(10));

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
= '114A';

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.
Thank you.



trouble in change attribute type from char to varchar2

Oracle is an object-relational database management system. It supports a large number of languages and application development frameworks. Its primary languages are SQL, PL/SQL and Java, but it also includes support for C and C++. Oracle also has its own enterprise modules and application server software.