using Like in query with Oracle db

 I am trying to use a query with this "like" statement with Oracle 8.1.7

campaigns.Query.Where(campaigns.Query.Name.Like(criteria.Name));

criteria.Name is a valid string value; 

When execute campaigns.Query.Load(),

I get  Oracle exception: ORA-12704: character set mismatch.

Any suggestions 

Can you post campaigns.Query.es.LastQuery? We do not test against Oracle 8, but you should be able to tell whether the SQL generated is valid for your version.

"SELECT * FROM \"PROMDBA\".\"DT_CAMP\" WHERE (\"NAME\" LIKE :NAME1 )"

Looks fine to me. 

        Value    "%THE COSBY SHOW%"    object {string}

and here is the parameter value as seen in the watch window. 

A quick Google search on that error indicates there may be some issues related to Oracle 8i that do not apply to 10g.

http://forums.asp.net/p/957619/1186441.aspx

Is this an NVARCHAR2 column? Can you change it to VARCHAR2?

It is a varchar2.  Is there a way to specify the parameter datatype? Or do you have an alternate suggestion besides just writing the sql?

Using DynamicQuery, there is no way to interact with the parameters that EntitySpaces creates. So, changing the parameter type from String to Empty is not possible. Does this only affect Where parameters? Does LoadAll() work?

LoadAll works fine.

Hi 

I have the same problem here, so it does not seem to have changed in newer versions. Did you ever get this problem solved?

Could be grat with some internal help here from the ES guys!

It does not matter wetter you use wildcards or not, ie. '%peted%' and 'peter' both fails with ORA-12704 error.

 Best regards

Peter Meldgaard