how set COLLATE UNICODE or COLLATE LOCALIZED in sqlite using DAL? When I am ordering sharp words, I want him to ignore the accents. I was saving using compute field, names without accent and uppercase to be able to sort, but then db size increases, an alternative would be to sort () doing this change in execution, but in this way I lose performance and practicality, so wanted to know if you have set COLLATE UNICODE or COLLATE LOCALIZED using DAL. That is, the DAL generates the following SQL:
SELECT * FROM foo ORDER BY to COLLATE UNICODE -- 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 [email protected]. For more options, visit https://groups.google.com/d/optout.
