SQLAlchemy截断VARCHAR(MAX) [英] SQLAlchemy Truncating VARCHAR(MAX)

问题描述

我正在使用python 2.7中的Flask-SQLAlchemy(.16)和SQL Alchemy(0.8.2)查询Microsoft SQL Server 2008.

I'm querying Microsoft SQL Server 2008 with Flask-SQLAlchemy (.16) and SQL Alchemy (0.8.2) in python 2.7.

当我尝试查询varchar(max)列时.它会将其截断为4096个字符.我在代码中尝试了不同的数据类型.字符串，文本，VARCHAR.

When I attempt to query the varchar(max) column. It is truncating it to 4096 characters. I've tried different data types in the code. String, Text, VARCHAR.

有什么想法让我的代码从我的专栏里提取所有数据吗?

Any thoughts to get my code to pull all the data from my column?

这是代码的一部分:

from web import db

class DynamicPage(db.Model):
    __tablename__ = 'DynamicPage'
    DynamicPageId = db.Column(db.Integer, primary_key=True)
    PageHtml = db.Column(db.VARCHAR)

查询:

pages = DynamicPage().query.all()

推荐答案

您是否正在使用ODBC? FreeTDS?对于较大的文本/二进制字段，ODBC具有固定的最大大小.在FreeTDS中，您需要设置文本大小设置以支持所需的大字段

Are you using ODBC? FreeTDS? ODBC has a fixed maximum size for large text/binary fields. In FreeTDS you need to set the text size setting to support as large a field as you need.

这篇关于SQLAlchemy截断VARCHAR(MAX)的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！