You'll need to check the docs for the exact data library you're using, but this is a common problem. Search 'app engine full text search' or 'app engine prefix query' for lots of discussion and workarounds.
They'll boil down to making a query that looks something like: SELECT * FROM City WHERE name >= "mo" AND name < "mo" + "\ufffd" Don't forget to case-normalize the field you're searching on. Robert On Thu, Aug 11, 2011 at 09:08, Timofey Tatarinov <[email protected]> wrote: > Hello, > > Is the text(or part of the text) searching on the field with type > List<String> possible, now? > > For example, we have class City with next structure: > > City { > protected Long id; > protected List<String> names; > protected List<String> nameLocales; > } > Field "names" stores all names of the city for different languages. > > And we want to find all cities which name started with "Mo". Results > are "Monte Carlo", "Moscow" and etc. How it can be done? > > Also, We interest in your opinion about our approach for > implementation of the multi-language site (database). For the example > above, names is ["Moscow", "Москва", ...], nameLocales is ["en", > "ru", ...]. If user has locale "en" his index will be '1' and cityName > = names[1] ("Moscow"). > > How do you store and use multi-language data on your site? > > Thanks > > -- > You received this message because you are subscribed to the Google Groups > "Google App Engine" group. > To post to this group, send email to [email protected]. > To unsubscribe from this group, send email to > [email protected]. > For more options, visit this group at > http://groups.google.com/group/google-appengine?hl=en. > > -- You received this message because you are subscribed to the Google Groups "Google App Engine" group. To post to this group, send email to [email protected]. To unsubscribe from this group, send email to [email protected]. For more options, visit this group at http://groups.google.com/group/google-appengine?hl=en.
