Re: Using DECODE with SELECT and LIKE
Posted by:
Cookie Le
Date: July 12, 2009 06:49PM
Thanks Rick!! I wanted to give up using DECODE() and ENCODE(). Without using these functions it was working fine. So it seems the problem is not just LOWER() and UPPER() alone, but when using it with ENCODE and DECODE(). Never thought functions LOWER() and UPPER() are the problem in mySQL. Any plans to fix it? BTW I am using version 5.0.41.
Once again many thanks Rick.
Cookie
ps. where is the best place/forum/topic to find out these sort of problems.
Subject
Written By
Posted
Re: Using DECODE with SELECT and LIKE
July 12, 2009 06:49PM
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.