Upgraded server returns memo where it use to return char
I just upgraded my server from 5.0.24 (32 bit) to 5.5.11 (64 bit).
I have this query (that is run in Delphi):
select
*,
IF(@prevLR=result_lab_request,@currentColor,
IF(@currentColor='R1',@currentColor:='R2',@currentColor:='R1')) as RColor,
.....more fields...whatever....
In the old server, the IF statement returned the letters 'R1' or 'R2' as a char (or string to Delphi). Now, since the upgrade, my Delphi program reports the field as being a memo field and it causes my program to break. Does anyone know why this is? And can the server be configured in some sort of compatibility mode so that it returns it as a char like it use to? (I really can't go and recompile and rollout all our code in a timely manner.)
Any help greatly appreciated.
Subject
Views
Written By
Posted
Upgraded server returns memo where it use to return char
3226
April 28, 2011 12:27PM
Sorry, you can't reply to this topic. It has been closed.
Content reproduced on this site is the property of the respective copyright holders.
It is not reviewed in advance by Oracle and does not necessarily represent the opinion
of Oracle or any other party.