| From: | Marko Kreen <marko(at)l-t(dot)ee> |
|---|---|
| To: | Loïc Courtois <lcourtois(at)netpartage(dot)fr> |
| Cc: | pgsql-general(at)postgresql(dot)org |
| Subject: | Re: JDBC and Accents |
| Date: | 2001-04-27 12:26:14 |
| Message-ID: | 20010427142614.A28684@l-t.ee |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general pgsql-jdbc |
On Fri, Apr 27, 2001 at 01:56:38AM +0200, Loïc Courtois wrote:
> Hello,
>
> I have some problems to display the accents in my db, using the JDBC and
> postgres 7.1.
>
> Apparently, all accents are replaced by a '?'.
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...
--
marko
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Loïc Courtois | 2001-04-27 12:36:21 | Re: JDBC and Accents |
| Previous Message | Tony Grant | 2001-04-27 12:00:19 | Re: JDBC and Accents |
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Peter T Mount | 2001-04-27 12:26:48 | Re: Loading JDBC70 is not an easy problem |
| Previous Message | Tony Grant | 2001-04-27 12:00:19 | Re: JDBC and Accents |