Where are list_text conversions stored? I have a field in a content type that is a list_text with a key/value pair where the key is stored in the database and the value is the text visible in the drop down menu.

I imported a large amount of data.  When I look at the data in a view or view a node, the key shows up.  However, after I edit the node, whether I've made changes or not, the value starts appearing in the view and in the node.  I would like this to be the case for every node, but can't possibly go though and manually edit each node.

Can anyone tell me where in the database the info that tells Drupal to use the translate the key to its value is stored?
The Field CRUD API could be a better approach instead of handmade DB calls.

If you must: Field creats two DB tables for every field they are called field_data_field_fieldname and field_revision_fieldname. The contents depends on the field type.