UPPER CASE problems

[eheidrich]

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!.

 

[ceco]

as far as I know postgre can only have one encoding which is set at databas creation type... if you can recreate the database with createdb -E and set the encoding you need

 

[Leland123]

Hi eheidrich,

You might give UNICODE codetype a try, if you can figure how to change the codetype from SQL_ASCII.

http://linux.kieser.net/java_pg_unicode.html

Regards,

LelandJ

Leland F. Jackson, CPA
Software - Master (TM)

http://www.smvfp.com

Nothing Runs Like the Fox