Search code examples
sqlsqlitelocaleuppercase

SQL changing value to uppercase with specified locale

In SQL, is there any function to uppercase a string with specified locale? Function upper(a_string) takes one parameter which is not enough for characters other than ASCII ones.

For example, I want to run a statement like this to change all the lowercase characters in a table with values containing Turkish characters:

UPDATE a_table SET a_field = UPPER(a_field, TurkishLocale);

Is there any function like this? If not, how can I define it?

Solution

  • You have to use the ICU extension module to get locale-dependent case functions in sqlite.