üÔÏ ÄÌÑ ÐÒÉÍÅÒÁ. á ×ÏÔ ÞÔÏ ÏÔ×ÅÞÁÅÔ Á×ÔÏÒ ÉÂÅËÓÐÅÒÔÁ:
NT> äÅÊÓÔ×ÉÔÅÌØÎÏ, ËÏÇÄÁ ibexpert ÂÕÄÅÔ ÕÖÅ ×ÙÄÁ×ÁÔØ alter table ? îÁÄÏ alter - ÒÅÄÁËÔÉÒÕÊÔÅ ÐÏÌÅ ÎÅ ÞÅÒÅÚ ÍÏÄÁÌØÎÙÊ ÒÅÄÁËÔÏÒ, Á ÐÒÑÍÏ × ÓÐÉÓËÅ ÐÏÌÅÊ, ÎÁÖÁ× ËÎÏÐÏÞËÕ Edit Table Structure ÎÁ ÔÕÌÂÁÒÅ. "Konstantin R. Beliaev" <[EMAIL PROTECTED]> wrote in message news:[EMAIL PROTECTED] > > Nikolay Trifonov wrote: >> update RDB$FIELDS set >> RDB$FIELD_SUB_TYPE = 0, >> RDB$CHARACTER_SET_ID = 52 >> where RDB$FIELD_NAME = >> (select RDB$FIELD_SOURCE >> from RDB$RELATION_FIELDS >> where (RDB$FIELD_NAME = 'NOTE') and (RDB$RELATION_NAME = 'FIRMS')); > > ôÙ ÞÅÇÏ ÍÅÎÑÅÛØ-ÔÏ? åÍÕ ÄÌÉÎÕ ÐÏÌÑ ÎÁÄÏ :-) > > update rdb$fields set > rdb$field_length=20, > rdb$character_length=20 /*ÜÔÏ ÄÌÑ ÏÄÎÏÂÁÊÔÎÙÈ ÓÉÍ×ÏÌÏ×, ÄÌÑ UTF8 ÄÏÌÖÎÏ > ÂÙÔØ ÞÔÏ-ÔÏ ÄÒÕÇÏÅ*/ > where rdb$field_length=10 /*ÓÔÁÒÁÑ ÄÌÉÎÁ, ÍÏÖÎÏ ÂÅÚ ÎÅÅ*/ > and rdb$field_name = > (select rfr.rdb$field_source > from rdb$relation_fields rfr > where rdb$relation_name = 'MYTABLE' > and rdb$field_name = 'MYFIELD'); > >
