Autocomplete with search for language strings

Hi,
I have a text field and created an autocomplete with a country list.
That works generally, but only with the names in the column of the mysql data base.
The search shall be with the translated names of the override file.
For example I have:
'cn_germany' in mysql, and 'Deutschland' in override with 'cn_germany'=>'Deutschland',
I want to have a search with 'deu' and 'Deutschland' should be shown. At the moment I can type in 'cn_g' and 'Deutschland' is shown.
How can I get this function?
Thanks, best regards
Eric

The auto complete just responds with whatever the results of your query are so if you want it to search the translated values then you need to add that to your query. I've no idea the SQL structure of your countries table so there isn't much I can suggest. The upcoming CB Quickstart package implements this autocomplete automatically if CBSubs is installed and it uses the below to search English, alternative name, and ISO codes for countries.

Thanks,
but I am looking for soemting like

XXX = the translated value of the language string, stored in the mysql data base.
Is that possible?
Thanks, best regards
Eric

If you've a database column for the translated title then yes set xxxxxx to whatever that column is. Typically you don't search for the translated value since that's unreasonable to be storing the country in multiple languages in the database. Probably only way to really do that efficiently is to use CB Code Field and its Auto Complete then use custom PHP to translate everything then filter the list down from there, but that's going to be a lot slower since you'll need to grab all the countries and translate them first.