Well, the upper case function is working fine if it wasn't for the fact I work in Brazil and here the language is portuguese which has some characters that are not used in English, such as "ê", "á", "ú", etc.
These kind of characters do not change to upper case when I use the upper case function of postgre! The default codetype of the datebase is SQL_ASCII.
I wounder if it is possible to fix this matter or maybe find a way around but at the database! I can't transfer the upper case transformation to the application!
Thanks to everyone who had tried to help me before and thanks again for the one's who are gonna give it some thought!.
These kind of characters do not change to upper case when I use the upper case function of postgre! The default codetype of the datebase is SQL_ASCII.
I wounder if it is possible to fix this matter or maybe find a way around but at the database! I can't transfer the upper case transformation to the application!
Thanks to everyone who had tried to help me before and thanks again for the one's who are gonna give it some thought!.