Jump to content
Sign in to follow this  
themeaty

ColdFusion - MySQL - Database structure

Recommended Posts

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

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.

37581[/snapback]

Share this post


Link to post
Share on other sites
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?

39920[/snapback]

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 ...???

Share this post


Link to post
Share on other sites

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!

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 ...???

39921[/snapback]

Share this post


Link to post
Share on other sites
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.

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)

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!

39923[/snapback]

ALTER is the command you want to look up.

Share this post


Link to post
Share on other sites

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

Share this post


Link to post
Share on other sites

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
Sign in to follow this  

×