NoPublic, bureaucrat, administrator
1,068
edits
Changes
no edit summary
=== CAST AS CHAR utf8 (mySQL) ===__NOEDITSECTION__
'''MySQL'''
<pre>
AND (`customdefinedfield`.`label` = _utf8'CDF-Area Reduction MDU')
</pre>
'''PostgreSQL'''
<pre>
AND (customdefinedfield.label = 'CDF-Area Reduction MDU')
</pre>
'''MySQL'''
<pre>
cast(`geopoint`.`latitude` as char charset utf8) AS `lat`
</pre>
'''PostgreSQL'''
<pre>
cast(geopoint.latitude as char) AS lat
</pre>
=== IF and IFNULL (mySQL) / CASE (PostgreSQL) statements ===__NOEDITSECTION__
