added a comment -
2003-01-02 19:21 utf8/mysql/search constraints.
The following jsp:
<mm:cloud logon="admin" pwd="admin2k">
<mm:listnodes type="news" constraints="subtitle LIKE 'Caf??©%'">
<mm:field name="subtitle" />
</mm:listnodes>
<mm:createnode type="news">
<mm:setfield name="subtitle"><mm:write value="Caf??©" /></mm:setfield>
</mm:createnode>
</mm:cloud>
gives in query log:
89 Query SELECT * FROM mm_news WHERE subtitle LIKE 'Caf�%'
INSERT INTO mm_news ( otype,owner,date,number,body,title,subtitle,intro ) VALUES ( 66,'admin',-1,215,'','','Caf??©','' )
in other words, are not consistent.
I think the problem is in getList of MMObjectBuilder:
ResultSet rs = stmt.executeQuery(query);
Principally this could be solved by a hook in MMJdbc2NodeInterface like this:
In MMObjectBuilder there is the function getQuery which calls QueryConvertor.altaVista2SQL(where,mmb.getDatabase());
So, e.g. in QueryConverte this hook of MMJdbc2NodeInterface could be called (implementing identity on default).
Bug
Resolved
Major
The following jsp:
<mm:cloud logon="admin" pwd="admin2k">
<mm:listnodes type="news" constraints="subtitle LIKE 'Caf??©%'">
<mm:field name="subtitle" />
</mm:listnodes>
<mm:createnode type="news">
<mm:setfield name="subtitle"><mm:write value="Caf??©" /></mm:setfield>
</mm:createnode>
</mm:cloud>
gives in query log:
89 Query SELECT * FROM mm_news WHERE subtitle LIKE 'Caf�%'
INSERT INTO mm_news ( otype,owner,date,number,body,title,subtitle,intro ) VALUES ( 66,'admin',-1,215,'','','Caf??©','' )
in other words, are not consistent.