글내용 입력용량에 한계가 있나요? > 그누3질답

그누3질답

글내용 입력용량에 한계가 있나요? 정보

그누보드 글내용 입력용량에 한계가 있나요?

본문

초보입니다.
그누보드를 사용해서 정보를 소개하는 사이트를 만들려고 하는뎅.
게시물 하나에 들어가는 글 내용의 입력용량에 한계가 있나요?
한참 입력하고 확인버튼을 눌렀는데..내용이 중간정도에서 잘리네요..
한계가 있다면 늘릴수 있는 방법은 무엇인가요?
소스를 보니 'wr_content' 값에 들어갈 내용의 길이가 한계가 있는거 같은데요..
DB에서 바꿔야한다면 어떻게 해야하는지요. 감사합니다.
  • 복사

댓글 전체

저는 cafe24계정 사용하는데요.. 거기선 웹php어드민이 있습니다. 따로 sql문 쓸필요없이 그냥 변경되는데요..아마 sql문으로 하려면 다음과 같이 될거 같습니다.
ALTER TABLE 테이블명 MODIFY 칼럼명 MEDIUMTEXT NOT NULL;
이곳에 가니 ALTER TABLE 명령어 사용법이 잘 나와 있네요..참고하세요.
http://www.webmania.co.kr/forum/apm/mysql8_03.php
11.3.2 The BLOB and TEXT Types

A BLOB is a binary large object that can hold a variable amount of data. The four BLOB types TINYBLOB, BLOB, MEDIUMBLOB, and LONGBLOB differ only in the maximum length of the values they can hold. See section 11.6 Column Type Storage Requirements.

The four TEXT types TINYTEXT, TEXT, MEDIUMTEXT, and LONGTEXT correspond to the four BLOB types and have the same maximum lengths and storage requirements. The only difference between BLOB and TEXT types is that sorting and comparison is performed in case-sensitive fashion for BLOB values and case-insensitive fashion for TEXT values. In other words, a TEXT is a case-insensitive BLOB. No case conversion takes place during storage or retrieval.

If you assign a value to a BLOB or TEXT column that exceeds the column type's maximum length, the value is truncated to fit.

In most respects, you can regard a TEXT column as a VARCHAR column that can be as big as you like. Similarly, you can regard a BLOB column as a VARCHAR BINARY column. The differences are:

You can have indexes on BLOB and TEXT columns with MySQL Version 3.23.2 and newer. Older versions of MySQL did not support this.
There is no trailing-space removal for BLOB and TEXT columns when values are stored, as there is for VARCHAR columns.
BLOB and TEXT columns cannot have DEFAULT values.
From version 4.1.0, LONG and LONG VARCHAR map to the MEDIUMTEXT data type. This is a compatibility feature.

MyODBC defines BLOB values as LONGVARBINARY and TEXT values as LONGVARCHAR.

Because BLOB and TEXT values may be extremely long, you may run up against some constraints when using them:

If you want to use GROUP BY or ORDER BY on a BLOB or TEXT column, you must convert the column value into a fixed-length object. The standard way to do this is with the SUBSTRING function. For example:
mysql> SELECT comment FROM tbl_name,SUBSTRING(comment,20) AS substr
    ->                ORDER BY substr;
If you don't do this, only the first max_sort_length bytes of the column are used when sorting. The default value of max_sort_length is 1024; this value can be changed using the -O option when starting the mysqld server. You can group on an expression involving BLOB or TEXT values by specifying the column position or by using an alias:
mysql> SELECT id,SUBSTRING(blob_col,1,100) FROM tbl_name GROUP BY 2;
mysql> SELECT id,SUBSTRING(blob_col,1,100) AS b FROM tbl_name GROUP BY b;
The maximum size of a BLOB or TEXT object is determined by its type, but the largest value you can actually transmit between the client and server is determined by the amount of available memory and the size of the communications buffers. You can change the message buffer size (max_allowed_packet), but you must do so on both the server and client ends. See section 7.5.2 Tuning Server Parameters.
Note that each BLOB or TEXT value is represented internally by a separately allocated object. This is in contrast to all other column types, for which storage is allocated once per column when the table is opened.

위의 주소에 가면 이런식으로 되어있던에요..
sql을 한번도 수정한적이 없는사람으로선 알아먹기가 힙드네요
mysql> SELECT comment FROM tbl_name,SUBSTRING(comment,20) AS substr
    ->                ORDER BY substr;
이걸로 수정하는것이 맞는지요?
저도 이전에 이것에 대해서 질문을 다른 사이트에 해봤는데..어려운듯..
고수님 부탁드려요...
정완구님 아시면 알려 주십시요.
wr_content 는 text 형으로 65535 바이트를 저장할 수 있습니다.
mediumtext 나 longtext 로 바꿔서 사용하시면 될것 같습니다.
아래 링크를 참고하세요.
http://www.mysql.com/doc/en/Column_types.html
© SIRSOFT
현재 페이지 제일 처음으로