AnsweredAssumed Answered

Case sensitivity when moving from MSQL to Oracle Db

Question asked by phil.smith on Feb 3, 2017

Hi All

 

This is my first post.

 

We are migrating from self-hosting to Bb hosting. We are
currently using a Windows/MSQL Server set-up - Bb hosting is using Linux/Oracle
(not sure what version(s) yet).

My building block that I am testing (which works and
performs as expected on our current windows set-up) searches the course using a
template

 

The problem I am experiencing is that the building block is
*not* working in the same way on the managed hosting system..

 

I’m just showing here a cut-down version of my code so you
get the idea - I have something like this:-

 

 

String strSearchTerm = %photography%

 

BbPersistenceManager bbPm = BbServiceManager.getPersistenceService().getDbPersistenceManager();
CourseSiteLoader cloader = (CourseSiteLoader) bbPm.getLoader(
CourseSiteLoader.TYPE );
CourseSite ctemplate = new CourseSite();
ctemplate.setTitle(strSearchTerm);
BbList courseList = cloader.load(ctemplate);

On our current pre-migration system
The results would effectively be

-----------------------
Photography course
Photography
PHOTOGRAPHY
Photography
phOtoGraPhy
----------------------

i.e. case insensitive
However on the managed hosting system
The return is just

----------------------
photography
----------------------
i.e. case sensitive


I can’t see anything in the API that could be used to force the search to be
case insensitive - I’m beginning to wonder if it’s the way the Oracle table has
been configured at the managed hosting COURSES Db table.

This situation will cause us big support issues.

Best wishes

 

&

Thank you in advance

Phil

.........................................................................

 

Philip Smith

Senior Learning Technologist

University of Cumbria

.........................................................................

Outcomes