Help - Search - Members - Calendar
Full Version: ColdFusion - MySQL - Database structure
SpamCop Discussion > Discussions & Observations > Geek/Tech Things > Software Issues
themeaty
Feb 1 2006, 12:30 PM
Hi, my client stores his biography in a SQL database and has reached an apparent limit on text (I'm thinking somewhere around 64,000 or 65,000 characters). The text is truncated each time he goes to save additional text to his biography.

Is it possible to increase the capacity? And how I might go about doing this?

Thanks!
-Meaty

QUOTE(Wazoo @ Dec 11 2005, 10:56 AM)
However, dipping into the MySQL stuff, describe ipb_posts defines the field "post" as Type "text" .... and looking elsewhere in the world for more input, I find the description of;
CHAR() A fixed section from 0 to 255 characters long.
VARCHAR() A variable section from 0 to 255 characters long.
TINYTEXT A string with a maximum length of 255 characters.
TEXT A string with a maximum length of 65535 characters.
BLOB A string with a maximum length of 65535 characters.
MEDIUMTEXT A string with a maximum length of 16777215 characters.
MEDIUMBLOB A string with a maximum length of 16777215 characters.
LONGTEXT A string with a maximum length of 4294967295 characters.
LONGBLOB A string with a maximum length of 4294967295 characters.
*

Wazoo
Feb 1 2006, 01:04 PM
QUOTE(themeaty @ Feb 1 2006, 11:30 AM)
Hi, my client stores his biography in a SQL database and has reached an apparent limit on text (I'm thinking somewhere around 64,000 or 65,000 characters). The text is truncated each time he goes to save additional text to his biography.

Is it possible to increase the capacity? And how I might go about doing this?
*


I may move this into the Geeky Things Forum section ....

As per the text quoted, yes, one could manually ALTER the Table in questionm (after makig a backup oe two) However, this doesn't mean that the application will stay happy or even functional. All that code would have to be looked at to see how this data is identified / handled.

As dbeil did here, is it possuble for this biography to start being broken up, say into chapters, date ranges, etc.? Then again, does the application allow this, is there also a posting / storage limit baased on a per user setting ...???
themeaty
Feb 1 2006, 01:53 PM
Hi Thanks for your reply. Well, the objective is to keep the entire text in one field. *blah* I just figured out the db is actually MySQL and the page is written in CF.

Is there a query statement that will return what type the db field is? I would like to know what the current field type is. And is there a query statement that will change the field type? I'm learning all this query stuff and any help is greatly appreciated!

Thanks!

QUOTE(Wazoo @ Feb 1 2006, 11:04 AM)
I may move this into the Geeky Things Forum section ....

As per the text quoted, yes, one could manually ALTER the Table in questionm (after makig a backup oe two)  However, this doesn't mean that the application will stay happy or even functional.  All that code would have to be looked at to see how this data is identified / handled. 

As dbeil did here, is it possuble for this biography to start being broken up, say into chapters, date ranges, etc.?  Then again, does the application allow this, is there also a posting / storage limit baased on a per user setting ...???
*

Wazoo
Feb 1 2006, 02:29 PM
QUOTE(themeaty @ Feb 1 2006, 12:53 PM)
Is there a query statement that will return what type the db field is? I would like to know what the current field type is.

CODE
mysql> use mysql;
mysql> show tables;
+-----------------+
| Tables_in_mysql |
+-----------------+
| columns_priv    |
| db              |
| func            |
| host            |
| tables_priv     |
| user            |
+-----------------+
6 rows in set (0.00 sec)

mysql> describe db;
+-----------------+-----------------+------+-----+---------+-------+
| Field           | Type            | Null | Key | Default | Extra |
+-----------------+-----------------+------+-----+---------+-------+
| Host            | char(60) binary |      | PRI |         |       |
| Db              | char(64) binary |      | PRI |         |       |
| User            | char(16) binary |      | PRI |         |       |
| Select_priv     | enum('N','Y')   |      |     | N       |       |
| Insert_priv     | enum('N','Y')   |      |     | N       |       |
| Update_priv     | enum('N','Y')   |      |     | N       |       |
| Delete_priv     | enum('N','Y')   |      |     | N       |       |
| Create_priv     | enum('N','Y')   |      |     | N       |       |
| Drop_priv       | enum('N','Y')   |      |     | N       |       |
| Grant_priv      | enum('N','Y')   |      |     | N       |       |
| References_priv | enum('N','Y')   |      |     | N       |       |
| Index_priv      | enum('N','Y')   |      |     | N       |       |
| Alter_priv      | enum('N','Y')   |      |     | N       |       |
+-----------------+-----------------+------+-----+---------+-------+
13 rows in set (0.00 sec)


QUOTE
And is there a query statement that will change the field type? I'm learning all this query stuff and any help is greatly appreciated!
*


ALTER is the command you want to look up.
themeaty
Feb 1 2006, 02:36 PM
Hi there, well glad I am on the right track because ALTER and DESCRIBE are the commands I figured I should use. Unfornately I can't figure out how to get ColdFusion to display the information.

<cfquery name="qryBio" datasource="#DbSource#" username="#dbUser#" password="#dbPass#">
DESCRIBE tblbio;
</cfquery>

<cfoutput>
#qryBio#
</cfoutput>

I have no idea what to attach to #qryBio# to make it display the information. If anybody is a CF expert I'd greatly appreciate some input. Thanks!
-Meaty
Wazoo
Feb 1 2006, 02:46 PM
http://www.thenetprofits.co.uk/coldfusion/faq/ may have something to help?

This is way off topic for here, so will be splitting this out and moving to the Geek - Software Forum section ....
This is a "lo-fi" version of our main content. To view the full version with more information, formatting and images, please click here.
Invision Power Board © 2001-2008 Invision Power Services, Inc.