Could you try the following plugin?http://dev.s-cubism.com/ plugin_suggest_widget This is an alternative autocomplete widget that I developed, and could handle unicode texts at least Japanese.
On 10月4日, 午後10:42, white fox <white.fox...@gmail.com> wrote: > hi, i use AutocompleteWidget for some of my field in db like this: > > dbMysql.qbp_video.game.widget = SQLFORM.widgets.autocomplete(request, > dbMysql.qbp_gameindex.title, limitby=(0,30), min_length=4) > > everything is ok,till I search a none englis word like "تست" (this is > a persian text) in this case autocomplete dose not work, because of > "escape" function use in javascript, the input text converted to > somthing like this "%u0645%u06CC%u0631%u0645" a unicode text. > > to solve this issue i change some code in sqlhtml.py in gluon: > > in AutocompleteWidget function around the line of 526: > > def callback(self): > if self.keyword in self.request.vars: > field = self.fields[0] > strSearch = self.request.vars[self.keyword] > strSearch = unicode(strSearch.replace('%', '\\'), "utf-8") > strSearch = strSearch.decode('unicode_escape') > rows = self.db(field.like(strSearch + '%'))\ > > .select(orderby=self.orderby,limitby=self.limitby,*self.fields) > > so i add strSearch variable and do some stuff to get it work > correctly. > now i want to know is this the only way to solve this issue? is it > correct way or i have security issue by doing this? > > thanks > > p.s: sorry for my bad english