MySQL Forums
Forum List  »  New in 4.1: Subqueries

concat with english and chinese problem
Posted by: david yang
Date: May 16, 2005 07:59PM

"select CASE issueDate='"+currentDate+"' WHEN 1 THEN concat('<a href=\"MY/MY_list.jsp?listCode=listcode1&Code=',Code,'\">',mainTitle,'[',issueDate,']','</a>','<img src=\"default/images/new.gif\">') ELSE concat('<a href=\"MY/MY_list.jsp?Code=listcode1&Code=',Code,'\">',mainTitle,'[',issueDate,']','</a>') END from code_book order by issueDate desc limit 6");

it list chinese with ??
why?

Options: ReplyQuote


Subject
Views
Written By
Posted
concat with english and chinese problem
4360
May 16, 2005 07:59PM


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.