Re: Charset encoding and accents

Barry Lind ha scritto:

> The charSet= option will no longer work with the 7.3 driver talking to a 
> 7.3 server, since character set translation is now performed by the 
> server (for performance reasons) in that senario.
> 
> The correct solution here is to convert the database to the proper 
> character set for the data it is storing.  SQL_ASCII is not a proper 
> character set for storing 8bit data.
> 

Probably I'm not enough clear about the problem. I *cannot* change 
charset type. SQL_ASCII really *is* the proper character set for my 
porpuses, because I actually work using psql and ODBC driver without any 
problem. I repeat: psql and ODBC retrives all data (with the accents) in 
the correct manner. Also, if I change the 
org.postgresql.core.Encoding.java making the decodeUTF8 method to return 
simply a new String(data), JDBC retrives the data from my SQL_ASCII 
database correctly! So my question is: why JDBC calls the decodeUTF8 
method also when the string is surely *not* an UTF-8 string? If JDBC 
could recognize that the string is *not* an UTF-8 string, then it will 
simply return a new String that is the right thing to do.
It's obvious that if JDBC receives from postgresql server a byte array 
representing a non-UTF8 string, and it a calls e method that wants as a 
parameter a byte array representing an UTF8 string, then it is a *bug*, 
because for non-UTF8 strings it must return a new String.

I hope to be enough clear this time.

Sincerely, I'm getting a bit frustrated from the problem, because I've 
projects to do and it prevents me to do that projects :-(

Greetings, Romaz
--
Davide Romanini