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 guess data must be Unicode encoded or no-go occurs. I have been told that there are "Latin-2 (ISO-8859-2) <-> Unicode" conversion functions, 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(at)postgresql(dot)org
>
>