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 TouchToneTommy 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
Jun 1, 2004
1
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
create connect string for informix using intersolv driver
Replies
2
Views
38
miketest
miketest
loginStd
  • Locked
  • Question
informix maximum length primary key
Replies
2
Views
60
cdlvj
cdlvj
map7
  • Locked
  • Question
Screen Field Length
Replies
0
Views
29
map7
map7
simpelli
  • Locked
  • Question
string to date conversion error
Replies
1
Views
76
vpshriyan
vpshriyan
rgbanse
  • Locked
  • Question
What is the maximum length of an Informix record?
Replies
2
Views
90
rgbanse
rgbanse

Part and Inventory Search

Sponsor

Back
Top