Home > Archive > PostgreSQL JDBC > January 2006 > encoding question









You are viewing an archived Text-only version of the thread. To view this thread in it's original format and/or if you want to reply to this thread please [click here]

 

Author encoding question
Gilbert, Antoine

2006-01-30, 11:25 am

Hi



I have a postgresql database, the encoding of the database is SQL_ASCII



When I use the postgresql driver, I have problem retrieving special
characters that display correctly in the postgres admin.



Any idea ?



Antoine




Kris Jurka

2006-01-30, 11:25 am



On Mon, 30 Jan 2006, Gilbert, Antoine wrote:

> I have a postgresql database, the encoding of the database is SQL_ASCII
> When I use the postgresql driver, I have problem retrieving special
> characters that display correctly in the postgres admin.
>


http://jdbc.postgresql.org/document...r-database.html

Kris Jurka

---------------------------(end of broadcast)---------------------------
TIP 3: Have you checked our extensive FAQ?

http://www.postgresql.org/docs/faq

Marc Herbert

2006-01-30, 1:24 pm

"Gilbert, Antoine" <AGilbert@korem.com> writes:

> Hi_I have a postgresql database, the encoding of the database is
> SQL_ASCII_When I use the postgresql driver, I have problem
> retrieving special characters


"special ASCII characters", mmmm... what is this ?

:-)


I looked for a solution to this issue some time ago and found this
"go-back-in-past" hack to change the encoding of the DB:

<http://thread.gmane.org/gmane.comp....uoia.general/38>

Simple tests were successful but it is provided without any warranty
of any kind; it stays a dirty hack. Anyone here knowing better?

If you don't know which charset your "special characters" are from, or
even worst if they are from different 8bit charsets, then you're just
dead. Well, at least some of these characters are.





---------------------------(end of broadcast)---------------------------
TIP 4: Have you searched our list archives?

http://archives.postgresql.org

Javier Yáñez

2006-01-31, 1:24 pm

I was this problem. The solution was to make a patch in the jdbc driver.
You can see it in
http://archives.postgresql.org/pgsq...03/msg00149.php

Gilbert, Antoine escribió:
>
>
> Hi
>
>
>
> I have a postgresql database, the encoding of the database is SQL_ASCII
>
>
>
> When I use the postgresql driver, I have problem retrieving special
> characters that display correctly in the postgres admin.



---------------------------(end of broadcast)---------------------------
TIP 3: Have you checked our extensive FAQ?

http://www.postgresql.org/docs/faq

Sponsored Links





Also available: Server administration forum archive | Web Design forum archive | Software forum archive | Hardware reviews archive | Programming forum archive

Copyright 2008 droptable.com