continuum-users mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Bjørn T Johansen <...@asp-as.no>
Subject Re: UTF-8?
Date Thu, 24 Jan 2008 09:53:38 GMT
That doesn't work and I think postgresql uses latin1 automatically when locale is set to latin1...
I still get the
following exception...:

org.postgresql.util.PSQLException: ERROR: character 0xefbfbd of encoding "UTF8" has no equivalent
in "LATIN1"


BTJ

On Thu, 24 Jan 2008 10:10:19 +0100
"Emmanuel Venisse" <emmanuel.venisse@gmail.com> wrote:

> You can set the charset on the jdbc URL
> 
> http://jdbc.postgresql.org/doc.html
> http://jdbc.postgresql.org/documentation/80/connect.html
> 
> Emmanuel
> 
> On Jan 24, 2008 9:32 AM, Bjørn T Johansen <btj@asp-as.no> wrote:
> 
> > I have alwasy used latin-1 or iso-8859-1 and tried switching to utf-8
> > several times but I always end up switching
> > back to iso-8859-1, it's the only thing that works 100%; it's always
> > something that doesn't work as expected when
> > using utf-8...
> >
> > And as I said, I tried using utf-8 as encoding for the database but that
> > didn't work (but I did not change my
> > locale....)
> >
> > But isn't there a config setting somewhere in continuum I can change to
> > make it work with iso-8859-1?
> >
> >
> > BTJ
> >
> > On Thu, 24 Jan 2008 09:22:40 +0100
> > Petter Måhlén <petter.mahlen@jadestone.se> wrote:
> >
> > > Yes - character encodings are always a nightmare. I'd say the by far
> > best
> > > solution (if at all possible) is to change your database configuration
> > and
> > > use UTF-8 throughout. Latin-1 is a bad idea, even if you're only
> > planning to
> > > support Norwegian in your application. I've lost count of the number of
> > > hours I've spent chasing down character encodings-related problems in
> > > different applications, but I've learned to always go for UTF-8
> > everywhere
> > > if I can.
> > >
> > > / Petter
> > >
> > > > -----Original Message-----
> > > > From: Bjørn T Johansen [mailto:btj@havleik.no]
> > > > Sent: Thursday, January 24, 2008 9:04 AM
> > > > To: continuum-users@maven.apache.org
> > > > Subject: Re: UTF-8?
> > > >
> > > > On Sat, 19 Jan 2008 11:20:18 +0100
> > > > Bjørn T Johansen <btj@asp-as.no> wrote:
> > > >
> > > > > I am trying to use PostgresSQL as our database but I have a problem
> > > > with character encoding. I am using ISO-8859-1
> > > > > as my encoding but it seems like Continuum insist on using UTF-8,
> > how
> > > > can I switch to ISO-8859-1?
> > > > >
> > > > >
> > > > > Regards,
> > > > >
> > > > > BTJ
> > > > >
> > > > >
> > ---------------------------------------------------------------------
> > > > --------------------------
> > > > > Someone wrote:
> > > > > "I understand that if you play a Windows CD backwards you hear
> > > > strange Satanic messages"
> > > > > To which someone replied:
> > > > > "It's even worse than that; play it forwards and it installs
> > Windows"
> > > > >
> > ---------------------------------------------------------------------
> > > > --------------------------
> > > >
> > > > No one knows how to get around this? We are running with ISO-8859-1 as
> > > > locale and creates the pgsql db with encoding=latin1...
> > > > When I use norwegian letters, it complains that continuum can't
> > convert
> > > > my Norwegain character and throws an exception...
> > > > If I create the db as UTF-8 or use the included Derby database, I no
> > > > longer get an error but I only get question marks back from
> > > > the db for the Norwegian letters.
> > > >
> > > > Can this really be so hard??
> > > >
> > > >
> > > > BTJ
> > >
> > >
> >

Mime
View raw message