Login ProductsSalesSupportDownloadsAbout |
Home » Technical Support » ElevateDB Technical Support » Support Forums » ElevateDB SQL » View Thread |
Messages 1 to 2 of 2 total |
TRIM BOTH function truncates final character (Unicode) |
Wed, Jan 30 2008 2:55 PM | Permanent 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. Regards, Dan |
Thu, Jan 31 2008 5:03 PM | Permanent Link |
Tim Young [Elevate Software] Elevate Software, Inc. 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 |
This web page was last updated on Friday, May 3, 2024 at 08:07 PM | Privacy PolicySite Map © 2024 Elevate Software, Inc. All Rights Reserved Questions or comments ? E-mail us at info@elevatesoft.com |