Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations Chriss Miller on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

String LENGTH

Status
Not open for further replies.
ParflaGush

ParflaGush

Programmer
Joined
Jun 1, 2004
Messages
1
Location
US
Using the LENGTH(char) function clips off any trailing spaces. Is there an alternative to LENGTH that does not remove the spaces?
 
Sort by date Sort by votes
Nope, informix always pads strings with spaces (for some unfathomable reason).
 
Upvote 0 Downvote
What are you trying to do ?

In fact, length() return the length of the string without trailing.
The length of the full string is the length you gave in the define clause... for a char variable.
 
Upvote 0 Downvote
Status
Not open for further replies.

Similar threads

miketest
  • Locked
  • Question Question
create connect string for informix using intersolv driver
Replies
2
Views
218
miketest
miketest
loginStd
  • Locked
  • Question Question
informix maximum length primary key
Replies
2
Views
202
cdlvj
cdlvj
map7
  • Locked
  • Question Question
Screen Field Length
Replies
0
Views
126
map7
map7
simpelli
  • Locked
  • Question Question
string to date conversion error
Replies
1
Views
398
vpshriyan
vpshriyan
rgbanse
  • Locked
  • Question Question
What is the maximum length of an Informix record?
Replies
2
Views
357
rgbanse
rgbanse

Part and Inventory Search

Sponsor

Back
Top