double quotes in unicode dbs

From: Peter Novodvorsky <nidd(at)altlinux(dot)com>
To: pgsql-general(at)postgresql(dot)org
Subject: double quotes in unicode dbs
Date: 2002-08-08 12:48:02
Message-ID: 871y99ldod.fsf@shamrock.office.altlinux.ru
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general


Hello!

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.

Is it bug of PostgreSQL multibyte support or mine syntax error?

Thanks.

--
Peter Novodvorsky nidd(at)myxomop(dot)com
http://garcia.myxomop.com/NiddWiki Deadheads, unite!

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Thomas Beutin 2002-08-08 13:08:08 Re: double quotes in unicode dbs
Previous Message Richard Huxton 2002-08-08 08:48:13 Re: Trigger which fires on commit? (Multi-table intergrity constraint)