Re: spanish characters in postgres - Mailing list pgsql-jdbc

From Patrik Lundgren
Subject Re: spanish characters in postgres
Date
Msg-id 000e01c2f04e$2a4f9890$0300a8c0@energy
Whole thread Raw
In response to spanish characters in postgres  ("Mario Rodriguez Villanea" <mrodriguez@AVANTICATEC.NET>)
List pgsql-jdbc
Most likely because you haven't set the charSet varaible in the
connection url. Americans always think english is the only language
spoken (written) and therefore the standard charSet doesn't permit any
special characters. Change your url to end with ?charSet=LATIN1. Example
: jdbc:postgresql://192.168.0.1/test?charSet=LATIN1

Regards,
Patrik Lundgren

-----Ursprungligt meddelande-----
Från: pgsql-jdbc-owner@postgresql.org
[mailto:pgsql-jdbc-owner@postgresql.org] För Mario Rodriguez Villanea
Skickat: Monday, March 17, 2003 3:11 PM
Till: pgsql-jdbc@postgresql.org
Ämne: [JDBC] spanish characters in postgres


Hi people, does anyone have idea why my special characters (á,é...,ú,ñ)
are returned by the jdbc driver as a "?" instead of the correct
character ???? When I send a normal query using psql the results looks
great

thanks

---------------------------(end of broadcast)---------------------------
TIP 5: Have you checked our extensive FAQ?

http://www.postgresql.org/docs/faqs/FAQ.html


pgsql-jdbc by date:

Previous
From: Tony Grant
Date:
Subject: Re: JDBC driver, PGSQL 7.3.2 and accents characters
Next
From: Marco Trevisan
Date:
Subject: Re: JDBC driver, PGSQL 7.3.2 and accents characters