Re: Problems with local alphabet

Nikola,

What character set is your database created with?  Issue 'select
getdatabaseencoding()' in psql.  You need a database created with the
appropriate character set for the data you are trying to store/retrieve
from that database.

thanks,
--Barry

Nikola Milutinovic wrote:

> Hi.
>
> I have PostgreSQL 7.1.3 and the latest JDBC driver installed. PostgreSQL has Unicode support built in.
>
> I have loaded a table with some text data containing "enhanced" ASCII encoded as Windows CP-1250. A bad move, I
guess,but that is what I had... 
>
> JDBC yields "?" in place of any of our local alphabet characters. I understand Java uses Unicode and that is fine. I
guessdata must be Unicode encoded or no-go occurs. I have been told that there are "Latin-2 (ISO-8859-2) <-> Unicode"
conversionfunctions, but cannot find them. 
>
> My plan is to convert cp-1250 to ISO-8859-2 and then to Unicode.
>
> Can someone help me with this task? Some advice, at least.
>
> Nix.
>
> ---------------------------(end of broadcast)---------------------------
> TIP 1: subscribe and unsubscribe commands go to majordomo@postgresql.org
>
>