The following bug has been logged online: Bug reference: 1478 Logged by: Tiago Magalhães Vieira Email address: [EMAIL PROTECTED] PostgreSQL version: 8.0.0-rc5 Operating system: Windows XP Description: Upper function does not work Details:
I have been experiencing some problems with the uppercase function, when the function has to make simple chars like 'c','a' etc it returns them in uppercase, but when it has to handle chars like 'á', 'é', 'ç' it does not do so. For example I have a field named 'med_type' in the table 'test' and one of this data in the field 'med_type' is 'Nutrição'. Then I make the query: SELECT upper(med_type) FROM test; It returns: 'NUTRIçãO' Even changed de characters enconding from UNICODE to ASCII and the problem still happens. Is this a bug or am I doing something wrong. Thanks in advance. ---------------------------(end of broadcast)--------------------------- TIP 4: Don't 'kill -9' the postmaster
