| Backtick Backquote in JDBC Driver SQL [message #57227] |
Fri, 10 July 2009 16:47  |
Eclipse User |
|
|
|
The SQL builder adds backticks (backquotes) to database and table names.
Teradata (which I'm accessing through a JDBC driver) can't interpret the
backquotes. Is there an way to make them optional, or replace them with
another delimiter? (Teradata uses double quotes (") or nothing instead of
the backquote (`).
|
|
|
| Re: Backtick Backquote in JDBC Driver SQL [message #436370 is a reply to message #57227] |
Thu, 30 July 2009 19:12  |
| Eclipse User |
|
|
|
The SQL Query Builder component uses double-quotes, so I'm surprised
that you are seeing back-quotes. Plus, it only quotes when necessary.
(That is when the identifier contains spaces or other unusual
characters.) Can you give a more detailed usage scenario?
Rob C. wrote:
> The SQL builder adds backticks (backquotes) to database and table names.
> Teradata (which I'm accessing through a JDBC driver) can't interpret the
> backquotes. Is there an way to make them optional, or replace them with
> another delimiter? (Teradata uses double quotes (") or nothing instead
> of the backquote (`).
>
>
|
|
|
| Re: Backtick Backquote in JDBC Driver SQL [message #596171 is a reply to message #57227] |
Thu, 30 July 2009 19:12 |
| Eclipse User |
|
|
|
The SQL Query Builder component uses double-quotes, so I'm surprised
that you are seeing back-quotes. Plus, it only quotes when necessary.
(That is when the identifier contains spaces or other unusual
characters.) Can you give a more detailed usage scenario?
Rob C. wrote:
> The SQL builder adds backticks (backquotes) to database and table names.
> Teradata (which I'm accessing through a JDBC driver) can't interpret the
> backquotes. Is there an way to make them optional, or replace them with
> another delimiter? (Teradata uses double quotes (") or nothing instead
> of the backquote (`).
>
>
|
|
|
Powered by
FUDForum. Page generated in 0.03667 seconds
Home