Subject Re: [Firebird-Java] How do I use quoted fields?
Author rrokytskyy
--- In Firebird-Java@y..., Marczisovszky Daniel <marczi@d...> wrote:
> MW> what exatly do you mean? do you mean the following?
> MW> ResultSet rs = st.executeQuery("select * from \"tblTemp\"");
> Actually you're not required to use " at all. You should use only if
> the fieldname or the columname is a reserved word, like PASSWORD or

This is not the only case. For example, Firebird does allow spaces in
quoted identifiers. And one more thing to consider: dialect 1 will
not be available in next major release, and they were talking about
disabling non-quoted identifiers, so, you'd better quote them. :)

Note, when you extract metadata, you get everything quoted.

Now Firebird works in compatibility mode, and there is a rule what
unquoted and quoted identifiers are considered to be the same. I
think, you can find it in dialect 3 description.

Best regards,
Roman Rokytskyy