FreeTDS Development Group

[Bob Kline <bkline AT rksystems.com>]

On Thu, 19 Apr 2001, Roman Hlynovski wrote:

> >
> > You're asking for trouble, but if you put double quotes around the
> > identifier, you can treat it as a delimited identifier instead of a
> > regular identifier.
> >
> >    CREATE TABLE "192.168.0.1" (....)
> yep, this works from enterprise manager but not from perl ;-)

No?  What's this then?

$ tfreetds.pl
SQL> CREATE TABLE "192.168.0.1" (id INTEGER, name VARCHAR(32))
SQL> INSERT INTO "192.168.0.1" VALUES(42, 'Jane Austin')
SQL> INSERT INTO "192.168.0.1" VALUES(43, 'Mary Shelley')     
SQL> SELECT * FROM "192.168.0.1"
        id: 42
      name: Jane Austin

        id: 43
      name: Mary Shelley

The above was run on linux 2.2.5-15, with perl 5.005_03, and freetds
0.51 built from sources November 19 of last year, against SQL Server
7.0 running on Windows NT 4.0 SP5.

-- 
Bob Kline
mailto:bkline AT rksystems.com
http://www.rksystems.com