{"id":365,"date":"2008-05-23T02:11:18","date_gmt":"2008-05-23T02:11:18","guid":{"rendered":"http:\/\/6teen.ru\/?p=216"},"modified":"2008-05-23T02:11:18","modified_gmt":"2008-05-23T02:11:18","slug":"4766","status":"publish","type":"post","link":"http:\/\/pblog.ru\/lab\/?p=365","title":{"rendered":"\u041a\u0430\u043a \u0437\u0430\u0441\u0442\u0430\u0432\u0438\u0442\u044c InterBase \u043f\u043e\u043d\u0438\u043c\u0430\u0442\u044c \u0440\u0443\u0441\u0441\u043a\u0438\u0439 \u044f\u0437\u044b\u043a"},"content":{"rendered":"<p>\u041a\u0430\u043a \u0437\u0430\u0441\u0442\u0430\u0432\u0438\u0442\u044c InterBase \u043f\u043e\u043d\u0438\u043c\u0430\u0442\u044c \u0440\u0443\u0441\u0441\u043a\u0438\u0439 \u044f\u0437\u044b\u043a<br \/>\n<!--more--><\/p>\n<pre class=\"alt2\" style=\"margin:0px; padding:6px; border:1px inset; width:580px; height:320px; overflow:auto\"><div>\u041a\u0430\u043a \u0437\u0430\u0441\u0442\u0430\u0432\u0438\u0442\u044c InterBase \u043f\u043e\u043d\u0438\u043c\u0430\u0442\u044c \u0440\u0443\u0441\u0441\u043a\u0438\u0439 \u044f\u0437\u044b\u043a\n\n\u041f\u0440\u0438 \u0441\u043e\u0437\u0434\u0430\u043d\u0438\u0438 \u0431\u0430\u0437\u044b \u0432\u0432\u0435\u0441\u0442\u0438 \u043f\u0430\u0440\u0430\u043c\u0435\u0442\u0440 \u0434\u043b\u044f \u043f\u043e\u0434\u0434\u0435\u0440\u0436\u043a\u0438 \u0440\u0443\u0441\u0441\u043a\u043e\u0433\u043e \u044f\u0437\u044b\u043a\u0430\n\nUPDATE RDB$FIELDS\nSET RDB$CHARACTER_SET_ID = 52\nWHERE RDB$FIELD_NAME = 'RDB$SOURCE'\n\n\u0438\u043b\u0438\n\n\u0417\u0430\u0441\u0442\u0430\u0432\u0438\u0442\u044c Interbase \u043f\u0440\u0438\u043d\u044f\u0442\u044c COLLATE PXW_CYRL \u043f\u043e \u0443\u043c\u043e\u043b\u0447\u0430\u043d\u0438\u044e\n\n(\u042d\u0442\u043e \u043e\u0447\u0435\u043d\u044c \u043f\u043e\u043b\u0435\u0437\u043d\u043e \u043f\u0440\u0438 \u043f\u0440\u044f\u043c\u043e\u0439 \u0440\u0430\u0431\u043e\u0442\u0435 \u0441 IB \u0438\u0437 \u0440\u0430\u0437\u043b\u0438\u0447\u043d\u043e\u0433\u043e CASE-\u0438\u043d\u0441\u0442\u0440\u0443\u043c\u0435\u043d\u0442\u0430\u0440\u0438\u044f, \u0442\u0438\u043f\u0430 PowerDesigner \u0438\u043b\u0438 ErWIN)\n\n\u0427\u0442\u043e\u0431\u044b \u043d\u0435 \u043f\u0438\u0441\u0430\u0442\u044c \u043a\u0430\u0436\u0434\u044b\u0439 \u0440\u0430\u0437 COLLATE, \u044f \u0441\u0434\u0435\u043b\u0430\u043b \u0441\u043b\u0435\u0434\u0443\u044e\u0449\u0435\u0435:\n\u0421\u043e\u0437\u0434\u0430\u043b \u0441\u043e\u0445\u0440\u0430\u043d\u0451\u043d\u043d\u0443\u044e \u043f\u0440\u043e\u0446\u0435\u0434\u0443\u0440\u0443\ncreate procedure fix_character_sets\nas\nbegin\nupdate\nrdb$character_sets\nset\nrdb$default_collate_name = 'PXW_CYRL'\nwhere\nrdb$character_set_name = 'WIN1251'\nand\nrdb$default_collate_name = 'WIN1251'\n;\nend\n\u0417\u0430\u043f\u0443\u0441\u0442\u0438\u043b \u0435\u0435 \u043e\u0434\u0438\u043d \u0440\u0430\u0437.\n\n\u0421\u043e\u0437\u0434\u0430\u044e \u0442\u0430\u0431\u043b\u0438\u0446\u044b \u0431\u0435\u0437 \u0443\u043a\u0430\u0437\u0430\u043d\u0438\u044f COLLATE.\n\u041f\u043e\u0441\u043b\u0435 \u0432\u043e\u0441\u0441\u0442\u0430\u043d\u043e\u0432\u043b\u0435\u043d\u0438\u044f \u0438\u0437 \u0430\u0440\u0445\u0438\u0432\u0430, \u0437\u0430\u043f\u0443\u0441\u043a\u0430\u044e \u0435\u0449\u0435 \u0440\u0430\u0437.\n\n<\/div><\/pre>\n<p><\/p>\n","protected":false},"excerpt":{"rendered":"<p>\u041a\u0430\u043a \u0437\u0430\u0441\u0442\u0430\u0432\u0438\u0442\u044c InterBase \u043f\u043e\u043d\u0438\u043c\u0430\u0442\u044c \u0440\u0443\u0441\u0441\u043a\u0438\u0439 \u044f\u0437\u044b\u043a<\/p>\n","protected":false},"author":3,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":[],"categories":[412,434],"tags":[1913,917,962,1063],"_links":{"self":[{"href":"http:\/\/pblog.ru\/lab\/index.php?rest_route=\/wp\/v2\/posts\/365"}],"collection":[{"href":"http:\/\/pblog.ru\/lab\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"http:\/\/pblog.ru\/lab\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"http:\/\/pblog.ru\/lab\/index.php?rest_route=\/wp\/v2\/users\/3"}],"replies":[{"embeddable":true,"href":"http:\/\/pblog.ru\/lab\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=365"}],"version-history":[{"count":0,"href":"http:\/\/pblog.ru\/lab\/index.php?rest_route=\/wp\/v2\/posts\/365\/revisions"}],"wp:attachment":[{"href":"http:\/\/pblog.ru\/lab\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=365"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"http:\/\/pblog.ru\/lab\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=365"},{"taxonomy":"post_tag","embeddable":true,"href":"http:\/\/pblog.ru\/lab\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=365"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}