I notice that on my local machine Mahara 17.04+ saves
João Jiménez Māori
in the title fields as 'João Jiménez Māori' and in the description fields as 'João Jiménez Māori'
But on cluster machines in 16.10 it saves
in the title fields as 'Jo<C3><A3>o Jim<C3><A9>nez M<C4><81>ori' in the description fields as 'João Jiménez M<C4><81>ori'
If I do a
SELECT 'João Jiménez Māori' AS test;
The both show the special chars correctly
But if I do
UPDATE view SET description = '<p>João Jiménez Māori</p>' where id = 10;
My local shows it like local above but cluster shows it like cluster above.
So the cluster setup for postgres must be different in the way it handles special utf8 characters
I notice that on my local machine Mahara 17.04+ saves
João Jiménez Māori
in the title fields as 'João Jiménez Māori'
and in the description fields as 'João Jiménez Māori'
But on cluster machines in 16.10 it saves
in the title fields as 'Jo<C3><A3>o Jim<C3><A9>nez M<C4><81>ori'
in the description fields as 'João Jiménez M<C4><81>ori'
If I do a
SELECT 'João Jiménez Māori' AS test;
The both show the special chars correctly
But if I do
UPDATE view SET description = '<p>João Jiménez Māori</p>' where id = 10;
My local shows it like local above but cluster shows it like cluster above.
So the cluster setup for postgres must be different in the way it handles special utf8 characters