On Wed, Jan 30, 2002 at 05:31:10PM -0200, Fernando Lozano thoughtfully expounded: > Running Red Hat Linux 7.1 and PostgreSQl 7.1.3 installed fomr the PGDG > rpms availabe at postgresql.org. My Java apps (using IBM Java SDK 1.3.0) > works fone with the database, but all accented characters (á, ã ó, ç, > ...) get garbaged. > > From psql I can insert and see the acents but Java cannot insert or > read the accents. Is this a bug of the driver or something I can fix > with a simple configuration? I've alread read posggresql manual and > found nothing. :-(
Fernando, I am not completely sure about this, but I believe that Java uses Unicode for all its character encoding, which maps to 'ordinary' ascii for unaccented characters, but diverges once out of that limited subset. You might want to check on the encoding you are using in Postgresql (even if only by default). If you use a Java app to create the table contents, things might be OK, but then if you access them in any other way you might run into trouble, due to encoding mis-matches. You may want to do some searches on the Internet to confirm what the default encoding is in Postgresql and Java. As long as I only worked in straight English, I had it easy. I am just beginning to run into encoding issues of my own as I try to compose mail in accented French to my cousin. I hope this helps -- Tom Porter [EMAIL PROTECTED] ------------------------------------------------------------------------ "On two occasions I have been asked [by members of Parliament], 'Pray, Mr. Babbage, if you put into the machine wrong figures, will the right answers come out?' I am not able rightly to apprehend the kind of confusion of ideas that could provoke such a question." _______________________________________________ Redhat-list mailing list [EMAIL PROTECTED] https://listman.redhat.com/mailman/listinfo/redhat-list
