Re: DatabaseMetaData.getExtraNameCharacters - Mailing list pgsql-jdbc

From Giuseppe Sacco
Subject Re: DatabaseMetaData.getExtraNameCharacters
Date
Msg-id 1117044622.27459.28.camel@localhost
Whole thread Raw
In response to Re: DatabaseMetaData.getExtraNameCharacters  (Kris Jurka <books@ejurka.com>)
Responses Re: DatabaseMetaData.getExtraNameCharacters
List pgsql-jdbc
Hi Kris,

Il giorno mer, 25-05-2005 alle 12:08 -0500, Kris Jurka ha scritto:
[...]
> Postgresql allows pretty much any character that is valid in your encoding
> to be used in an unquoted identifier, so trying to list them all would be
> impossible, but there should be no problem using them.

Thanks for your reply, but I would really like to have a list of valid
or invalid characters in order to test the string before executing the
statement. There are characters that should be excluded: $%&#^°§[} ...

If the valid characters list is really huge, is there any list of
invalid characters and a JDBC3.0 method that return it?

I checked that mySQL gives '#$' as result string. What are the results
given by other JDBCs?

Bye,
Giuseppe


pgsql-jdbc by date:

Previous
From: Dave Cramer
Date:
Subject: Re: BIGINT <-> java.lang.String auto cast
Next
From: Kris Jurka
Date:
Subject: Re: DatabaseMetaData.getExtraNameCharacters