MMBase

Postgresql and case insensitive ordering.Needless use of UPPER.

Details

  • Type: Bug Bug
  • Status: Open Open
  • Priority: Major Major
  • Resolution: Unresolved
  • Affects Version/s: 1.8.0
  • Fix Version/s: 2.0.0
  • Component/s: Database Layer
  • Description:
    Hide
    original bugid: #6845
    Depedning of the Locale used during initdb, order by is always case insensitive in postgresql. There is no need for specifying order by UPPER(title).

    On the other hand, perhaps warning must be logged if you want to order by case sensitively. This is probably only possible if the locale was C or POSSIX. The inverse is true if the locale was something like a real language.
    Show
    original bugid: #6845 Depedning of the Locale used during initdb, order by is always case insensitive in postgresql. There is no need for specifying order by UPPER(title). On the other hand, perhaps warning must be logged if you want to order by case sensitively. This is probably only possible if the locale was C or POSSIX. The inverse is true if the locale was something like a real language.

Activity

People

Dates

  • Created:
    2006-07-05 22:08
    Updated:
    2009-07-31 16:05