31.03.2011 13:38, Dmitry Yemanov wrote: > 31.03.2011 15:19, Dimitry Sibiryakov wrote: > >> SET NAMES UTF8; >> CONNECT TEST; >> CREATE TABLE w_t (a VARCHAR(30000) CHARACTER SET win1251); >> INSERT INTO w_t VALUES (RPAD(_win1251'уй', 32000, _win1251'ё'); >> SET SQLDA_DISPLAY on; >> SELECT a FROM w_t; > > There's no longish field here.
Oops, I made a mistake in script. Field must be 32000 chars long and rpad param - only 30000. >RPAD evaluates the expression and throws > as soon as it overflows the 32K limit. It works as designed. It is not RPAD or INSERT that throw error, but SELECT because it has to convert 30000 russian letters into 60000 of 120000 bytes in UTF8. -- SY, SD. ------------------------------------------------------------------------------ Create and publish websites with WebMatrix Use the most popular FREE web apps or write code yourself; WebMatrix provides all the features you need to develop and publish your website. http://p.sf.net/sfu/ms-webmatrix-sf Firebird-Devel mailing list, web interface at https://lists.sourceforge.net/lists/listinfo/firebird-devel
