I have some tables when the primary key are char(10) in like I have id's with property assigned (by requeriments of the system) sometimes I put keys with 7 characters or 8. But the problem is when I have to do a finder, because the querys dont return nothing. I have to put the data with blank characters to find something. This problem also occur when I have to do a load().

If someone know how can I do my querys I will be very thankful.

The database is padding out to match the fixed width type so you will need to pad out your id names as well. A small utiltiy method will pad it out before you use it as an argument to the query to the database.