Skip site navigation (1) Skip section navigation (2)

Re: JDBC Latin1 problem

From: "J(dot) Michael Crawford" <jmichael(at)gwi(dot)net>
To: smota <samuelmota(at)gmail(dot)com>, pgsql-jdbc(at)postgresql(dot)org
Subject: Re: JDBC Latin1 problem
Date: 2004-08-04 20:18:36
Message-ID: 6.1.1.1.2.20040804161557.0327cec0@pop.suscom-maine.net (view raw or flat)
Thread:
Lists: pgsql-jdbc
<<How are you outputing this data?  Velocity, JSP and others "template 
processors" allow you to specify the character set>>

   We're currently outputting the data from our own java application, which 
will be turned into a servlet in a few weeks.  We skipped JSP and Velocity 
because we had a very unique data schema with very unique needs (it would 
have taken more time to do it the "easy" way in this case).  Thus, I'm not 
sure I can find an environment variable.

   Thanks for the tip, though.

   BTW, all jibberish comes directly from the database, and displays as 
such using System.out.println().

	- Mike


At 03:01 PM 8/4/2004, smota wrote:
 >How are you outputing this data?
 >
 >Velocity, JSP and others "template processors" allow you to specify
 >the character set, make sure it's set for a compatible one (usually
 >ISO-8859-1).
 >
 >You can set the LC_ALL environment variable to pt_BR.ISO8859-1 (of
 >course you can switch pt_BR for your locale code) and then start your
 >AS.
 >(for me this was the solution, setting all character set processing
 >options on Webwork and Velocity was not enough).
 >
 >Regards,
 >
 >Samuel
 >
 >---------------------------(end of broadcast)---------------------------
 >TIP 7: don't forget to increase your free space map settings


In response to

pgsql-jdbc by date

Next:From: Oliver JowettDate: 2004-08-04 22:38:14
Subject: Re: [HACKERS] postgres and Jdbc 2.0
Previous:From: Kris JurkaDate: 2004-08-04 19:35:38
Subject: Re: Wrong column names in ResultSetMetaData

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group