Archives of the TeradataForum
Message Posted: Sun, 29 Jun 2003 @ 11:47:49 GMT
| Subj: | | Re: Dash character in user/database name? |
| |
| From: | | McCall, Glenn D |
Another (and in my opinion one of the few legitimate reasons to use " in queries) is that it allow you to use names that include
characters outside of the standard english ones (i.e. letters, numbers, _ and $). Sure you can use ; () and all sorts of other weird and
wonderful characters, but I am not talking about those characters.
I am talking about accented characters and double byte characters. By using double quotes you can create table and column names in the
native language of non-english speaking users. This is extremly useful where an application presents table and column names to the user to
select (eg. a graphical query builder). By doing this, you can present names to users that are in there native language and then formulate
those names into actual queries by wrapping the users' choices in double quotes. This is one of the reasons why GUI query tools often
enclose your selections names in "".
Consequently, whenever I develop S/W that allows a user to select a table or columnname from a list that I obtain from the DBC
catalogoues I would wrapp it in "" when formulating the query.
Glenn Mc
| 
