diff options
| author | mkanat%bugzilla.org <> | 2007-12-29 13:34:34 +0100 |
|---|---|---|
| committer | mkanat%bugzilla.org <> | 2007-12-29 13:34:34 +0100 |
| commit | 44d7e6bdfee8136788331d038dd375e6a3b63c48 (patch) | |
| tree | 6d9240aecab83e84052d991b5fa53e6e1b067686 | |
| parent | e621696be0f092e348e4534e1855c0a3146c2c9e (diff) | |
| download | bugzilla-44d7e6bdfee8136788331d038dd375e6a3b63c48.tar.gz bugzilla-44d7e6bdfee8136788331d038dd375e6a3b63c48.tar.xz | |
Bug 410134: [Oracle] Make Oracle case-insensitive for Bugzilla
Patch By Xiaoou Wu <xiaoou.wu@oracle.com> r=mkanat, a=mkanat
| -rw-r--r-- | Bugzilla/DB/Oracle.pm | 3 |
1 files changed, 3 insertions, 0 deletions
diff --git a/Bugzilla/DB/Oracle.pm b/Bugzilla/DB/Oracle.pm index a970e3193..f89a72ab0 100644 --- a/Bugzilla/DB/Oracle.pm +++ b/Bugzilla/DB/Oracle.pm @@ -79,6 +79,9 @@ sub new { $self->do("ALTER SESSION SET NLS_TIMESTAMP_FORMAT='YYYY-MM-DD HH24:MI:SS'"); $self->do("ALTER SESSION SET NLS_LENGTH_SEMANTICS='CHAR'") if Bugzilla->params->{'utf8'}; + # To allow case insensitive query. + $self->do("ALTER SESSION SET NLS_COMP='LINGUISTIC'"); + $self->do("ALTER SESSION SET NLS_SORT='BINARY_AI'"); return $self; } |