Icon View Thread

The following is the text of the current message along with any replies.
Messages 1 to 2 of 2 total
Thread TRIM BOTH function truncates final character (Unicode)
Wed, Jan 30 2008 2:55 PMPermanent Link

Dan Rootham
Hi Tim,

EDB Manager Ver 1.07 Build 3 Unicode

SELECT
 term,
 TRIM(BOTH ' ' FROM term) AS trimmed_term
FROM
 Dict_DEU

Expected result:  leading & trailing spaces trimmed
Actual result:  leading & trailing spaces trimmed, and final non-space character truncated

Not urgent for me, but I thought you'd like to know. Smiley

Regards,
Dan





Thu, Jan 31 2008 5:03 PMPermanent Link

Tim Young [Elevate Software]

Elevate Software, Inc.

Avatar

Email timyoung@elevatesoft.com

Dan,

<< Expected result:  leading & trailing spaces trimmed
Actual result:  leading & trailing spaces trimmed, and final non-space
character truncated >>

I will make sure this is fixed for the next release.   I also have to see
what is going wrong with our test for this, because we do have an automated
test in place.  However, I don't think it is Unicode-specific.

--
Tim Young
Elevate Software
www.elevatesoft.com

Image