Thanks for the comments. yes I am currently on windows platform.
The 255 length is for the varchar type. I guess i will have to look into PostgreSQL. I would be willing to learn another operating system if it would get the job done & is stable. B/c I am in the intial stages of developing a website. --- Martin Moss <[EMAIL PROTECTED]> wrote: > > > > > > Currently I am basically set up to use perl and an > > access db. But I understand that access has a > limited > > simultaneous user support. I guess a person could > set > > up several databases with different dsns & perl > > conditionals, but that would double and triple > space > > on a server. > > > > I am considering mysql b/c it supposedly is a bit > more > > supportive for simultaneous users, and I noticed > that > > mysql fields has a length of 1 - 255. I think > some of > > my fields will be greater than 255. Do you guys > agree > > with the 255 length limitation? > > > I think you are misinformed. Mysql has a BLOB type > which can take a much > larger Field Length. > Access and Perl don't work comfortably together in > my experience. > > > Does anyone have a solution in mind? > > > > I know this may be little off subject for perl, > but I > > am a perl scripter & will utilize perl, I am > having a > > little difficulty selecting the right db to use > right > > now. > > :) :) > > > > You didn't specify if you are using UNIX or Windows, > I assume you're using > Windows. Do you have a UNIX machine available to run > your Database, would > probably relieve you of some of the headaches you > would have, but unless you > were familliar with Unix would probably introduce > more. > > Under UNIX:- > I have used MySQL farely extensively under Linux, > But Recently I've been > hearing good things about PostgreSQL. I cannot back > them up with evidence of > my own, but I'm sure others here can. I've heard sub > selects are supported > in PostgreSQL But know they aren't available in > MySQL. I've also seen Large > MySQL Tables (MYISAM Type, of size approx 1GB) > become corrupted easily and > regularly however These have all been recoverable > errors. > > Check out some Earlier posts today which are also > relevant to your question. > > Under Windows:- > > Personally I'd throw your copy of Access out of the > nearest window and pray > you never need to use it again, however If that > Luxury isn't available to > you, you could try Perl's ODBC Modules to use > Access. > If you can though, try running Microsoft SQLServer > instead of Access at the > very least, (it sounds better than access on paper, > but I have no experience > of it, so don't take this bit of advice as gospel). > > MySql do a release for Windows, but I haven't used > it. I would guess it > would do the job far better than Access or SQL > Server though. > > Regards > > Marty > > _______________________________________________ > Perl-Win32-Users mailing list > [EMAIL PROTECTED] > http://listserv.ActiveState.com/mailman/listinfo/perl-win32-users ===== Regards, Investorclb __________________________________________________ Do You Yahoo!? Send your FREE holiday greetings online! http://greetings.yahoo.com _______________________________________________ Perl-Win32-Users mailing list [EMAIL PROTECTED] http://listserv.ActiveState.com/mailman/listinfo/perl-win32-users
