Thread: 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

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