How read/write long text from/to DB

[robin and jim]

Is your data Unicode?  If so, have you tried the NTEXT data type?


"laodizhu" <laodizhu at sina.com> wrote in message
news:8067f6d4.0208181710.4a918952 at posting.google.com...
> Hello everyone:
>      I'm using mxODBC.Windows to R/W long/text(<100KByte) to MSSql.
> I tryed use data type "text", "binary" to create table column, and
> when I insert record to database, I get error message like "data
> length too long " or "type mismatch" etc.
>      Any one can make suggestion in long text binary database programing
> in python? I had read mxODBC help, but still not know what should I do.
> Code sample is special valueable for me.
>      Other DB Module solution is also welcome.
>
>      Thanks at advance.
>
>      laodizhu at sina.com
>