Under 2.3.6 I am observing a problematic behaviour: I have a sqlite table with a 'discounttable' column declared as 'text collate localized' When running following query:
select * from discount where (discounttable = ?) order by priority asc the data is not being returned when the parameter is: 'ŚWIĘTCZA;#3ZN#JOA' (contains polish accents). Doing the same with: select * from discount where (discounttable collate binary = ?) order by priority asc or select * from discount where (discounttable like ?) order by priority asc (with like parameter being '%ŚWIĘTCZA;#3ZN#JOA%') does return the expected rows. The original query does not work no matter what locale I set in the phone. Am I missing something. Leszek Gawron -- You received this message because you are subscribed to the Google Groups "Android Developers" 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/android-developers?hl=en
