MySQL Forums
Forum List  »  Other Migration

Upgraded server returns memo where it use to return char
Posted by: Mark Grover
Date: April 28, 2011 12:27PM

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.

Options: ReplyQuote


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.