Please help:
I have this:
print "DEBUG: query = " + str(query)
result = mydb(query).select(*column_names)
print db._lastsql
This will print this into the log:
DEBUG: query = ((((record.application = 3) AND (record.entity = 24)) AND
(record.is_deleted = 'F')) AND ((record.is_deleted = 'F') AND
(record.string_1 = 'Puskás Ferenc')))
Please observe the accented 'a' character: "á"
This will raise this error (from the GAE logs):
print db._lastsql File
"/base/data/home/runtimes/python27_experiment/python27_lib/versions/1/google/appengine/runtime/request_environment.py",
line 92, in write self._request.errors.write(data) File
"/base/data/home/runtimes/python27_experiment/python27_lib/versions/1/google/appengine/api/logservice/logservice.py",
line 286, in write for line in cStringIO.StringIO(lines):
UnicodeEncodeError: 'ascii' codec can't encode character u'\xe1' in
position 212: ordinal not in range(128)
However:
1. If I comment out the print db._lastsql part, my app suddenly works as
expected,
2. Except, querying on "Puskas Ferenc" and "Puskás Ferenc" both retrieves
the same item from the table (which has an "á").
Maybe, can someone give me a hint on what's going on here?
My server connection collation is set to utf8mb4_unicode_ci and the table
collation to utf8_general_ci (this was all default in Google Cloud SQL, I
have not changed them)
Thank you!
--
Resources:
- http://web2py.com
- http://web2py.com/book (Documentation)
- http://github.com/web2py/web2py (Source code)
- https://code.google.com/p/web2py/issues/list (Report Issues)
---
You received this message because you are subscribed to the Google Groups
"web2py-users" group.
To unsubscribe from this group and stop receiving emails from it, send an email
to web2py+unsubscr...@googlegroups.com.
For more options, visit https://groups.google.com/d/optout.
