</pre>
=== CAST AS CHAR CHARSET utf8 and _utf8 (mySQL) ===__NOEDITSECTION__In some (older) mySQL versions, UTF-8 was not the default character set and strings thus needed to be explicitly converted to UTF-8. This is not the case in PostgreSQL and UTF-8 related syntax as used in MySQL does not work in PostgreSQL. Below are two examples encountered in {{IMSMANG}} views.
'''MySQL'''
<pre>