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 <rui.t...@gmail.com> 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 web2py@googlegroups.com
To unsubscribe from this group, send email to
web2py+unsubscr...@googlegroups.com
For more options, visit this group at
http://groups.google.com/group/web2py?hl=en
-~----------~----~----~----~------~----~------~--~---
