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

Reply via email to