HTML Help
HTML Help Central . com

» Online Users: 44

0 members and 44 guests
No Members online
Most users ever online was 695, 02-16-2011 at 07:01 AM.

» Site Navigation

 > FAQ

» Domains For Sale

Results 1 to 3 of 3
  1. #1
    Join Date
    Sep 2003
    Location
    Ohio
    Posts
    591

    Long strings in MySQL database

    I need to store many long text strings to a MySQL database. I have very little experience with them (I've only used them for authentication). Is there a maximum number of characters (or bytes) that a database can store in one field? Some of the strings could be over 5000 characters, with over a hundred of them at any given time. Maybe there's a better way to do this? I really can't split them up very easily, I guess if I had to I could but that just allows more room for errors. Anybody have any suggestions?

    Matt

  2. #2
    Join Date
    Dec 2002
    Location
    Seattle, WA
    Posts
    1,306
    depends on the column type you use, see: http://dev.mysql.com/doc/mysql/en/st...-overview.html for further info

  3. #3
    Join Date
    Aug 2001
    Location
    New Jersey, USA
    Posts
    1,940
    Yeah, a longblob or longtext will do just fine...you could probably use something even smaller, 5000 bytes is like 4.8KB's...not even close to the limit of 4GB's.

    If you need to store anything larger then 4GB's, I wouldn't store it directly in MySQL as you may have problems with data that large...just link to a file located on the server. You may also want to look into data compression if its just plain text and that large...binary compression on text files is extremely good.

    It'll be hard for most computers to open up 4GB text files though...

Similar Threads

  1. Database (mysql) and php
    By Liamsorsby in forum PHP
    Replies: 3
    Last Post: 01-06-2011, 11:32 PM
  2. MYSQL udate strings efficiency
    By vtecin in forum Database Web Development
    Replies: 2
    Last Post: 08-10-2008, 06:29 AM
  3. Inputting data into mySql database
    By jpwwalsh in forum Other Languages ( ASP / Perl / Python / TCL / Ruby / ColdFusion / etc)
    Replies: 1
    Last Post: 02-04-2004, 02:48 PM
  4. Long Tim no see...
    By HTMLCreator in forum Chat Central
    Replies: 13
    Last Post: 09-10-2003, 11:11 PM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
Powered by vBadvanced CMPS v4.1.1