MySQL Forums
Forum List  »  General

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.

Options: ReplyQuote


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.