Re: JDBC and Accents

On 27 Apr 2001 14:26:14 +0200, Marko Kreen wrote:

>
> What is your database encoding?
>
> You can insert whatever stuff you want into db and
> psql displays it fine - it does not care what it is.
>
> But JDBC 7.1 does use database encoding for understanding
> stuff it gets and translating it to Java strings.  So if your
> db encoding is SQL_ASCII but data is LATIN1 you are screwed.
> Same with data in LATIN1 and db in UNICODE.  etc...

How do I set it?

Searching docs for "database encoding" gives:

Sorry, but search returned no results.

Is this the locale value that can be passed at start up? I will document
this in my Ultradev - Posgresql HOWTO because it is JDBC related.

Cheers

Tony Grant

--
RedHat Linux on Sony Vaio C1XD/S
http://www.animaproductions.com/linux2.html