Thanks, But i found out the problem im using a old version of MySQLdb and for some reason give me this problem now is updated every thing work fine :D
On Fri, Jun 5, 2009 at 3:43 PM, Yarko Tymciurak <[email protected]> wrote: > Perhaps this will help: > > http://dev.mysql.com/doc/refman/5.1/en/charset-applications.html > > ...you might want > > DEFAULT COLLATE utf8_unicode_ci; > > instead of utf8_general_ci; > > > On Fri, Jun 5, 2009 at 12:24 AM, NewBeen <[email protected]> wrote: > >> >> Hi, >> >> Its me again, now when I put the code in the production(Linux box) >> server i get this error, but in the computer i use to develop(Windows >> xp) this don't happen. >> >> Here i leave the error some idea?? PS: I double check the charset in >> the database 10 time already :S >> >> ############# ERROR ############################## >> Error traceback >> >> Traceback (most recent call last): >> File "H:\python\web2py_win\web2py_source\svn\gluon\restricted.py", >> line 107, in restricted >> File "/var/www/web2py/applications/dominos_times/controllers/ >> default.py", line 112, in <module> >> File "H:\python\web2py_win\web2py_source\svn\gluon\globals.py", line >> 97, in <lambda> >> File "H:\python\web2py_win\web2py_source\svn\gluon\tools.py", line >> 1207, in f >> File "/var/www/web2py/applications/dominos_times/controllers/ >> default.py", line 98, in customcreate >> form = crud.create('databasedp',onvalidation=lambda form:r(form), >> onaccept=lambda form: f(form)) >> File "H:\python\web2py_win\web2py_source\svn\gluon\tools.py", line >> 1638, in create >> File "H:\python\web2py_win\web2py_source\svn\gluon\tools.py", line >> 1596, in update >> File "H:\python\web2py_win\web2py_source\svn\gluon\sqlhtml.py", line >> 580, in accepts >> File "H:\python\web2py_win\web2py_source\svn\gluon\sql.py", line >> 1440, in insert >> File "H:\python\web2py_win\web2py_source\svn\gluon\sql.py", line >> 717, in <lambda> >> File "/usr/lib/python2.5/site-packages/MySQLdb/cursors.py", line >> 146, in execute >> query = query.encode(charset) >> UnicodeDecodeError: 'ascii' codec can't decode byte 0xc3 in position >> 299: ordinal not in range(128) >> >> # # sample index page with internationalization (T) >> >> >> >> response.menu =[['Login', False, URL(r=request, f='user/login')], >> >> ['Logout', False, URL(r=request, f='user/logout')]] >> >> >> >> def index(): >> >> >> >> link_create=URL(r=request, f='customcreate') >> >> link_search=URL(r=request, f='list_all') >> >> >> >> return dict(link_create=link_create, link_search=link_search) >> >> >> >> >> >> # # uncomment the following if you have defined "auth" and "crud" in >> models >> >> def user(): >> >> return dict(form=auth()) >> >> >> >> >> >> @auth.requires_login() >> >> def data(): >> >> >> >> return dict(form=crud()) >> >> >> >> >> >> @auth.requires_login() >> >> >> >> def list_all(): >> >> >> >> form=FORM(TABLE(TR('Select Store:', SELECT('All', >> 1,2,3,4,5,6,7,8,9,10,11,12,13,14, value='All', _name='store_id', >> requires=IS_NOT_EMPTY())), >> >> TR('Reason:', SELECT('All','Afp\xf6ntun', # HERE >> i try to write the word with ÆÐÖÞ and them i change to hex some >> result >> >> 'Anna\xf0', >> >> 'Ekki heimild', >> >> '\xd3m\xf3ttekin', >> >> '\xd3s\xf3tt', >> >> 'Remake', >> >> 'R\xf6ng b\xfa\xf0', >> >> 'Sein', >> >> 'S\xedmamist\xf6k', >> >> 'Staffamatur', >> value='All', _name='reason', requires=IS_NOT_EMPTY())), >> >> TR('Date', INPUT(_class="date", _id="date_field", >> _type="date",_name="date", _value="All")), >> >> ("",INPUT(_type="submit",_value="Go")))) >> >> >> >> query="" >> >> db_store=db.databasedp.Store_id >> >> db_reason=db.databasedp.reason >> >> db_date=db.databasedp.date >> >> >> >> st_store=request.vars.store_id >> >> st_reason=request.vars.reason >> >> st_date=request.vars.date >> >> >> >> if st_date!="All": >> >> q_date=db_date==st_date >> >> else: >> >> q_date=db_date==db_date >> >> >> >> if st_store!="All": >> >> q_store=db_store==st_store >> >> else: >> >> q_store=db_store==db_store >> >> >> >> if st_reason!="All": >> >> q_reason=db_reason==st_reason >> >> else: >> >> q_reason=db_reason==db_reason >> >> >> >> if st_store=="All" and st_reason=="All" and st_date=="All": #Se >> todos forem all >> >> query=db().select(db.databasedp.ALL) >> >> else: >> >> query=db(q_store&q_date&q_reason).select() >> >> >> >> >> >> return dict(form=form, query=query) >> >> >> >> >> >> @auth.requires_login() >> >> def customread(): >> >> id_order=request.args[0] >> >> return dict(crudread=crud.read(db.databasedp, int(id_order))) >> >> >> >> @auth.requires_login() >> >> def customupdate(): >> >> id_order=request.args[0] >> >> #if db.databasedp.id(id_order): >> >> crud_output=crud.update(db.databasedp, int(id_order) ,next=URL >> (r=request,args=request.args[0])) >> >> >> >> return dict(crudupdate=crud_output) >> >> >> >> @auth.requires_login() >> >> def customcreate(): >> >> >> >> try: >> >> if session.create: >> >> pass >> >> except: >> >> session.create=[] >> >> >> >> form = crud.create('databasedp',onvalidation=lambda form:r(form), >> onaccept=lambda form: f(form)) >> >> >> >> return dict(form=form) >> >> >> >> def f(form): >> >> >> >> if session.create: >> >> session.create.append(form.vars.id) >> >> else: >> >> session.create=[form.vars.id] >> >> >> >> def r(form): >> >> form.vars.total_payd=form.vars.total_amount-form.vars.total_credit >> >> >> response._vars=response._caller(customcreate) >> ########################################## >> >> > > > > --~--~---------~--~----~------------~-------~--~----~ You received this message because you are subscribed to the Google Groups "web2py Web Framework" 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/web2py?hl=en -~----------~----~----~----~------~----~------~--~---
