Changes

Difference MySQL PostGreSQL

335 bytes added, 08:14, 19 June 2014

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__

• ← Older edit
• Newer edit →

Evinek

NoPublic, bureaucrat, administrator

1,068

edits