MySQL VARCHAR strange column behavior

Posted by Mat on Stack Overflow See other posts from Stack Overflow or by Mat
Published on 2010-05-11T15:19:22Z Indexed on 2010/05/11 15:24 UTC
Read the original article Hit count: 265

Filed under:
|

I have the following SQL statement which returns a single record as expected:

select * from geodatasource_cities C,
geodatasource_countries D
where C.CC_FIPS = D.CC_FIPS
and D.CC_ISO='AU'
and UCASE(TRIM(C.FULL_NAME_ND)) LIKE '%JAN JUE%';

However, If I use the following SQL statement, no records are returned. I have only changed the LIKE clause to an equal to clause:

select * from geodatasource_cities C,
geodatasource_countries D
where C.CC_FIPS = D.CC_FIPS
and D.CC_ISO='AU'
and UCASE(TRIM(C.FULL_NAME_ND)) = 'JAN JUE';

Can anybody please help me understand why this may be happening?

© Stack Overflow or respective owner

Related posts about mysql-query

Related posts about varchar