<div>
The Varchar datatype can be as large as 8000 characters, so something is is askew. &nbsp;What sor of application are you using to select the data are connected through an ODBC connection?<br />

</div>


The Varchar datatype can be as large as 8000 characters, so something is is askew.  What sor of application are you using to select the data are connected through an ODBC connection?


<div>
hi<br />
yes Varchar can support until 8000 but when i select the record, my result has been truncated to 255.<br />
I am using SQL dblibrary, Sql Direct access API.
</div>


hi
yes Varchar can support until 8000 but when i select the record, my result has been truncated to 255.
I am using SQL dblibrary, Sql Direct access API.

<div>
<div class="content wysiwyg-content">
I am facing the problem that when i select a record from a column more than 255 bytes(varchar), data is truncated at 255 bytes. how can i solve this problem?
</div>
</div>


I am facing the problem that when i select a record from a column more than 255 bytes(varchar), data is truncated at 255 bytes. how can i solve this problem?

can DB library support char more than 255

Microsoft SQL Server is a suite of relational database management system (RDBMS) products providing multi-user database access functionality.SQL Server is available in multiple versions, typically identified by release year, and versions are subdivided into editions to distinguish between product functionality. Component services include integration (SSIS), reporting (SSRS), analysis (SSAS), data quality, master data, T-SQL and performance tuning.