The best solution using SQLITE that I found for my problem https://stackoverflow.com/questions/5492508/ignore-accents-sqlite3
2018-06-01 13:53 GMT-03:00 Junior Phanter <[email protected]>: > Thank you Antony. I'm trying to use executesql. > > 2018-06-01 13:04 GMT-03:00 Anthony <[email protected]>: > >> You can execute arbitrary SQL via db.executesql(), but I don't think >> there is an easy way to add the collate expression to a standard >> DAL-generated query (you could generate a SQL string via the ._select() >> method and then manipulate it and ultimately pass it to db.executesql()). >> >> Would it make more sense to define the collation behavior of the column >> directly in the SQLite schema so you don't have to worry about specifying >> it on a per-query basis (or do you sometimes want different collation >> behavior for this particular column)? >> >> Anthony >> >> >> On Friday, June 1, 2018 at 11:43:45 AM UTC-4, Junior Phanter wrote: >>> >>> 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. >> > > -- 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.
