Re: double quotes in unicode dbs

Hi Peter,

On Thu, Aug 08, 2002 at 04:48:02PM +0400, Peter Novodvorsky wrote:
>    I'm writing native driver for OpenOffice.Org for PostgreSQL. I used
> to use 8-bit charset db to test a driver (koi8-r, actually), and when I
> tried UNICODE db I've found the following problem: queries with double
> quotes don't work. For example,
>
>        SELECT * FROM TEST1;
>
> works, but
>
>        SELECT * FROM "TEST1";
>
> doesn't. I'd gladly remove all quoting of table names, but it is done
> by sdbc layer of OpenOffice.Org, and I don't want to hack it.
>
If You are quoting the table names they are treated case sensitive.
Is there an table TEST1 in Your database?

Greetings,
-tb
--
Thomas Beutin                             tb@laokoon.IN-Berlin.DE
Beam me up, Scotty. There is no intelligent live down in Redmond.