long field trancation.

long field trancation.

am 31.03.2005 09:48:53 von Nick Zhokhov

------=_NextPart_000_01E7_01C535E7.9CD74BC0
Content-Type: text/plain;
charset="koi8-r"
Content-Transfer-Encoding: quoted-printable

Hi,
MySQL v 4.1.10 -nt
MyODBC 3.51.11-1
in frame of media wiki package.
I used MyODBC in order to make some transformation of data.
The problem is that ODBC driver cuts CUR_TEXT fields to ~160kb.
Some fields in table CUR
CUR_ID int(8) unsigned
CUR_NAMESPACE tinyint(2) unsigned
CUR_TEXT MEDIUMTEXT
....
If I execute
SELECT * FROM CUR WHERE CUR_NAMESPACE =3D12
and then see max length for CUR_TEXT I find ~160kb.

I know that record with maximum length CUR_TEXT is ~700kb and has =
primary key CUR_ID =3D 5121
if I execute
SELECT * FROM CUR WHERE CUR_ID =3D 5121
I get one record and no trancation on CUR_TEXT and maximum lentgh is =
~700kb that is right.

Is it bug or feature?

Thank in advance.

--Nick Zhokhov



------=_NextPart_000_01E7_01C535E7.9CD74BC0--