#47 Upper instruction and Spanish language

open
nobody
None
5
2007-02-06
2007-02-06
No

Hi,

as we can see in http://www.sqlite.org/lang_expr.html, Upper instruction doesn't converts accents (`,´) and other UTF8 characters to Upper.

If we have a this table:

ID nombre
---------------
1 cortés
2 marín
3 sánchez

When we try a select like

"select count nombre from pepe where upper(nombre)='CORTÉS'"

it does not work.

If you need to compare those values, you could try with LOWER instruction (Lower works fine!).

Discussion

Get latest updates about Open Source Projects, Conferences and News.

Sign up for the SourceForge newsletter:





No, thanks