Bugs item #716887, was opened at 2003-04-07 20:05
Message generated for change (Comment added) made by pilhuhn
You can respond by visiting:
https://sourceforge.net/tracker/?func=detail&atid=376685&aid=716887&group_id=22866
Category: JBossCMP
Group: v3.0 Rabbit Hole
Status: Open
>Resolution: Accepted
Priority: 5
Submitted By: Vinh Nguyen (softwaremasters)
>Assigned to: Heiko W.Rupp (pilhuhn)
Summary: Incorrect length function syntax for Sybase
Initial Comment:
The correct Sybase syntax for the length function is
char_length, not len.
----------------------------------------------------------------------
>Comment By: Heiko W.Rupp (pilhuhn)
Date: 2003-11-12 18:08
Message:
Logged In: YES
user_id=217112
len() has only been added in 12.5.0.3 to extend
MS-compatibility.
----------------------------------------------------------------------
Comment By: Heiko W.Rupp (pilhuhn)
Date: 2003-11-12 17:56
Message:
Logged In: YES
user_id=217112
Sybase manual says:
Determining column length with system functions
Use the char_length string function and datalength system
function to determine column length:
* char_length returns the number of characters in the
column, stripping trailing blanks for variable-length datatypes.
* datalength returns the number of bytes, stripping
trailing blanks for data stored in variable-length columns.
When a char value is declared to allow NULLS, Adaptive
Server stores it internally as a varchar.
----------------------------------------------------------------------
Comment By: Heiko W.Rupp (pilhuhn)
Date: 2003-09-26 17:11
Message:
Logged In: YES
user_id=217112
What is the difference between datalength(?1) and
char_length(?1) . Or are they equivalent?
----------------------------------------------------------------------
You can respond by visiting:
https://sourceforge.net/tracker/?func=detail&atid=376685&aid=716887&group_id=22866
-------------------------------------------------------
This SF.Net email sponsored by: ApacheCon 2003,
16-19 November in Las Vegas. Learn firsthand the latest
developments in Apache, PHP, Perl, XML, Java, MySQL,
WebDAV, and more! http://www.apachecon.com/
_______________________________________________
JBoss-Development mailing list
[EMAIL PROTECTED]
https://lists.sourceforge.net/lists/listinfo/jboss-development
