Resolve inconsistent results when invoking LOWER() in C vs. UTF8 locale databases

[evergreen-equinox.git] / Open-ILS / src / perlmods / lib / OpenILS / Reporter / SQLBuilder.pm

diff --git a/Open-ILS/src/perlmods/lib/OpenILS/Reporter/SQLBuilder.pm b/Open-ILS/src/perlmods/lib/OpenILS/Reporter/SQLBuilder.pm
index 637cbc5..b7d7177 100644 (file)
--- a/Open-ILS/src/perlmods/lib/OpenILS/Reporter/SQLBuilder.pm
+++ b/Open-ILS/src/perlmods/lib/OpenILS/Reporter/SQLBuilder.pm
@@ -596,7 +596,7 @@ sub toSQL {
        my $params = $self->resolve_param( $self->{_column}->{params} );
        my $start = $$params[0];
        my $len = $$params[1];
-       return 'LOWER("' . $self->{_relation} . '"."' . $self->name . '")';
+       return 'evergreen.lowercase("' . $self->{_relation} . '"."' . $self->name . '")';
 }
 
 sub is_aggregate { return 0 }