convert a cck field from integer to string (text)
You would have to change the type in field data and field revision tables and add the FIELD_NAME_format column in both the tables.
Change the type and module columns in field_config to 'text'. And change the data column in field_config and field_config_instance tables.

For more info on this you can visit this link.