Hello I have followed problem:
Table: CREATE TABLE test ( field1 mediumtext ); Insert: INSERT INTO test VALUES ('2222222(100 Kb of '2')222'); Select1: SELECT field1 FROM test; OK. I get 100 Kb of '2'. Select2: SET CHARACTER SET cp1251_koi8; SELECT field1 FROM test; ??? I get only 34465 byte. I use mysql 3.23.33, 4.0.0-alpha on FreeBSD 4.3, 4.4. If I use text instead mediumtext Select2 work correctly. But I use string >65 Kb. If I use longtext, longblob or mediumblob problem repeat. Can I use long string with SET CHARACTER SET cp1251_koi8 option? --- Dmitry Grigoryev --------------------------------------------------------------------- Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php