php - how to fetch data using zend db select if data is in "Portuguese"? -

php - how to fetch data using zend db select if data is in "Portuguese"? -

how fetch info using zend db select if info in "portuguese"? "amapá - ap" having text in database. "á" creating problem.

i using query:

select * tablename state_name 'amapá - ap'

it runs in database create create problem zend db select. suggest solution?

whenever need handle special characters zend_db should set charset type "utf8". set charset type utf8, add together next property in config file:

resources.db.params.charset=utf8

now work fine.

php mysql database zend-framework select