So there is nothing like C escape strings? (\", \',\\,etc.)
And the way to do it is to leave the field name, column name or string the
way it is, close it into double quotes and duplicate all double quotes in
the identificator?
Brona
> SELECT "brono'-kluc""ka" from 'brona''-klucka';
> ^^
> Double the " withing a "..." string
>
>
> --
> D. Richard Hipp -- [EMAIL PROTECTED] -- 704.948.4565
> Bronislav Klučka wrote:
> > Hi,
> > I've done this:
> > create table 'brona''-klucka' ('brona''-kluc"ka' int)
> > insert into 'brona''-klucka' ('brona''-kluc"ka') values (1);
> >
> > if I try: select * from 'brona''-klucka'; then it realy returns
> >1<, but how
> > can I address the field?
> >
> > select "brona''-kluc"ka" from 'brona''-klucka'; //of course wrong
> > select "brona''-kluc\"ka" from 'brona''-klucka'; //not so
> obvious but wrong
> > too
> > select 'brona''-kluc"ka' from 'brona''-klucka'; //
> returns >brona'-kluc"ka<
> > it's treating the column as a string...
> >
> > I figured out that there have to be double quotes (select
> "name","surname"
> > from person) to treat the indentificators as column names, not
> the strings
> > (that happens if you use quote (select 'name','surname' from
> person)). But
> > what to do if there are some double quotes in field name????
> > Or is there some exact description of single-double quote behaviour???
> >
>
>
>
> ---------------------------------------------------------------------
> To unsubscribe, e-mail: [EMAIL PROTECTED]
> For additional commands, e-mail: [EMAIL PROTECTED]
>
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
