Re: Selecting on non ASCII varchars

From: Marc Herbert <Marc(dot)Herbert(at)emicnetworks(dot)com>
To: pgsql-jdbc(at)postgresql(dot)org
Subject: Re: Selecting on non ASCII varchars
Date: 2005-10-05 14:22:37
Message-ID: 87vf0cjb6a.fsf@meije.emic.fr
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-jdbc

Vadim Nasardinov <vadimn(at)redhat(dot)com> writes:

> On Tuesday 04 October 2005 16:16, Jeremy LaCivita wrote:

>> Correct me if i'm wrong, but that says to me that the Strings were
>> in UTF-8 already, but Java didn't know it, so it couldn't send them
>> to postgres properly.
>
> It's meaningless to ask what encoding a String has. String are
> sequence of chars -- they don't have an encoding.

Actually they are encoded using UTF-16

<http://java.sun.com/developer/technicalArticles/Intl/Supplementary/>

Granted, this is the no-brainer "same value" encoding... as long as
codepoint < U+FFFF

In response to

Browse pgsql-jdbc by date

  From Date Subject
Next Message Russ Tennant 2005-10-05 22:18:20 "org.postgresql.util.PSQLException: This ResultSet is closed" in call to rst.getString(..)
Previous Message exeden 2005-10-05 08:30:06 Connection to PostgreSQL server behind proxy