Hello,
Do you have other databases that work with UNICODE? You can check the
encoding of all your databases with 'psql -l'. You can check if you can
create any unicode databases with 'createdb -E UNICODE mytestdatabase'.
I didn't use postgresql on solaris yet, so the following is just a
guess: maybe you need to install additional solaris packages. For
example to get tomcat/java working with utf-8/unicode/.. instead of
plain ascii, we need at least the following on our systems:
SUNWloc System Localization
SUNWlocx System Localization (64-bit)
SUNWeuluf UTF-8 L10N For Language Environment User Files
SUNWeulux UTF-8 L10N For Language Environment User Files (64-bit)
Kind regards,
Dries Verachtert
On Wed, 2002-12-18 at 13:39, Andreas Joseph Krogh wrote:
> -----BEGIN PGP SIGNED MESSAGE-----
> Hash: SHA1
>
> Hi all!
> I get the following error when trying to connect to a pg-7.3 database on
> Solaris8 with the 7.3 JDBC-driver.
> Here is my output on the Solaris box:
> www=> select version();
> version
> - -----------------------------------------------------------------------
> PostgreSQL 7.3 on sparc-sun-solaris2.8, compiled by GCC gcc (GCC) 3.2
> (1 row)
>
> www=> set client_encoding = 'UNICODE';
> ERROR: Conversion between UNICODE and LATIN1 is not supported
> www=>
>
>
> Here is the same commands on my Linux box:
> andreak=# select version();
> version
> - --------------------------------------------------------------------------------------------------
> PostgreSQL 7.3 on i686-pc-linux-gnu, compiled by GCC gcc (GCC) 3.2 (Mandrake
> Linux 9.0 3.2-1mdk)
> (1 row)
>
> andreak=# set client_encoding = 'UNICODE';
> SET
> andreak=#
>
> =================
>
> Does anybody know why this doesn't work on Solaris8? They are both compiled
> with "./configure --with-pam" and multibyte support is enabled as default in
> 7.3. I can allways recompile the JDBC-drivers with "set client_encoding =
> 'LATIN1'; show autocommit" in AbstractJdbc1Connection.java, but that seems
> hacky.
>
> - --
> Andreas Joseph Krogh <andreak@officenet.no>
> The difference between insanity and genius is measured by success
> -----BEGIN PGP SIGNATURE-----
> Version: GnuPG v1.0.7 (GNU/Linux)
>
> iD8DBQE+AGxvUopImDh2gfQRAoLbAJ9y9ZOZNS513zahIkPMDP5tJ1zSGACgj6Xo
> lxVLkYwE/I/sxRRRNvRSZFo=
> =FsMP
> -----END PGP SIGNATURE-----
>
>
> ---------------------------(end of broadcast)---------------------------
> TIP 1: subscribe and unsubscribe commands go to majordomo@postgresql.org