Patrick, Very helpful. I will look into the coverting the addresses. Thanks.
On 9/28/05, Patrick <[EMAIL PROTECTED]> wrote: > > Historically any form of punctuation, parameter delimiter, or filepath > delimiter in either a database name, field or column name, file or table > name would not be recommended; even if the RDBMS or File Handler allows > it. > > If you are able to stick to alphanumeric characters using underscores > characters if needed for clarity, you go a long way for portability across > various operating systems. Also, IPv4 addresses are readily converted to > single 32bit integers that minimize the need for dotted quartets. > > Early versions of MySQL allowed periods. This caused OS incompatibility > issues. To my knowledge this was fixed prior to version 3 and you are no > longer allowed periods in database or table names. This, in my thinking, > is > a good thing by assuring greater portability and easier migration. > > I hope this helps. > > Pat... > > [EMAIL PROTECTED] > CocoNet Corporation > SW Florida's First ISP > 825 SE 47th Terrace > Cape Coral, FL 33904 > > > ----- Original Message ----- > From: "Chance Ellis" <[EMAIL PROTECTED]> > To: <mysql@lists.mysql.com> > Sent: Wednesday, September 28, 2005 12:57 PM > Subject: Re: Table names with periods > > > Instead of criticizing people's designs without understanding the > requirements why don't you just answer the question, or don't you know > either? > > > On 9/28/05, Martijn Tonies <[EMAIL PROTECTED]> wrote: > > > > > > > >I am sure this has been asked before but I can't seemed to find it. > > > Canyou create table names with periods in them? I need to create > tables > > >based on the IP address of machines (x.x.x.x) > > > > Ehm. Why? > > > > Instead of going the "silly table names" route, why not try a different > > design? > > > > With regards, > > > > Martijn Tonies > > Database Workbench - tool for InterBase, Firebird, MySQL, Oracle & MS > SQL > > Server > > Upscene Productions > > http://www.upscene.com > > Database development questions? Check the forum! > > http://www.databasedevelopmentforum.com > > > > > > -- > > MySQL General Mailing List > > For list archives: http://lists.mysql.com/mysql > > To unsubscribe: > http://lists.mysql.com/[EMAIL PROTECTED] > > > > > > > -- > MySQL General Mailing List > For list archives: http://lists.mysql.com/mysql > To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED] > >
