• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 243
  • Last Modified:

can DB library support char more than 255

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?
0
glt10
Asked:
glt10
  • 2
1 Solution
 
spcmnspffCommented:
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?
0
 
glt10Author Commented:
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.
0
 
spcmnspffCommented:
Sheeeesh that's old.  That's a legacy technology from the old SyBase days!  This is a physical limitation of the API function. Is it possible to switch to ADO and avoid the API calls altogether?  If not try breaking it up and concatenating it on the front end.  Something like:

Select Left(MyField,255) A, Right(MyFeild(Len(MyField - 255)

Now you've accomodated for a possible lentgh of 510, and so on  . . .  Now just concatenate the fiekd in the fromnt end.

I know it's not fun but  . . .
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Free Tool: Site Down Detector

Helpful to verify reports of your own downtime, or to double check a downed website you are trying to access.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now