현재 오라클에 clob타입으로 데이타가 들어있습니다.
근데 이것을 sybase로 이전할려고 하는데.... 어떤 타입인지 잘 몰라서요.
Sybase가 너무 생소해서요...
해당 타입이 있는지 궁금합니다.
그리고 sybase에서도 오라클에 tigger에 해당하는 것도 있는지??
그럼 좋은 하루 보내세요. ^^
여기서 SYBASE라 함은 무얼 의미하나요? 사이베이스사가 공급하는 데이터베이스에는 ASE SYBASE IQ ASA 이렇게 세가지가 있답니다 문의하신 내용의 답변이 위 셋중 어떤거냐에 따라 달라집니다
sybase쪽은 잘 몰라서..... 제가 지금 이전 할려는 것은 ASE입니다. 조금 더 신중하게 올렸어야 하는데???
text라는 데이터 타입이 있습니다.
text columns are variable-length columns that can hold up to 2,147,483,647 (231 - 1) bytes of printable characters.
create table blurbs (au_id id not null, copy text null)Data structures used for storing text and image dataWhen you allocate text or image data, a 16-byte text pointer is inserted into the row you allocated. Part of this text pointer refers to a text page number at the head of the text or image data. This text pointer is known as the first text page (FTP). The FTP contains two parts: The text data page chain, which contains the your text and image data and is a double-linked list of text pages.The optional text-node structure, which is used to access the user text dataOnce an FTP is allocated for text or image data, it is never deallocated. If an update to an existing text or image data row results in fewer text pages than are currently allocated for this text or image data, Adaptive Server deallocates the extra text pages. If an update to text or image data sets the value to NULL, all pages except the FTP are deallocated.Figure 1-1 shows the relationship between the datarow and the text pagesFigure 1-1: Relationship between the textpointer and datarows
When you allocate text or image data, a 16-byte text pointer is inserted into the row you allocated. Part of this text pointer refers to a text page number at the head of the text or image data. This text pointer is known as the first text page (FTP).
The FTP contains two parts:
The text data page chain, which contains the your text and image data and is a double-linked list of text pages.
The optional text-node structure, which is used to access the user text data
Once an FTP is allocated for text or image data, it is never deallocated. If an update to an existing text or image data row results in fewer text pages than are currently allocated for this text or image data, Adaptive Server deallocates the extra text pages. If an update to text or image data sets the value to NULL, all pages except the FTP are deallocated.
Figure 1-1 shows the relationship between the datarow and the text pages
