tag:blogger.com,1999:blog-8891884956165580080.post3545088560813537466..comments2024-03-26T08:45:04.816+01:00Comments on Database Architects: Type Providers in C++Thomas Neumannhttp://www.blogger.com/profile/15209393663505917383noreply@blogger.comBlogger2125tag:blogger.com,1999:blog-8891884956165580080.post-58577121822621311462015-01-16T12:33:22.148+01:002015-01-16T12:33:22.148+01:00You accidentally posted that to a different blog p...You accidentally posted that to a different blog post, I will answer you in the original one.Thomas Neumannhttps://www.blogger.com/profile/15209393663505917383noreply@blogger.comtag:blogger.com,1999:blog-8891884956165580080.post-14369586918337418692015-01-16T12:29:21.181+01:002015-01-16T12:29:21.181+01:00> The VARCHAR comparisons use the literal value...> The VARCHAR comparisons use the literal values, and thus compare as not equal.<br /><br />As far as I understand it, this is wrong. The ANSI standard is that trailing spaces are *not* significant in comparison of VARCHAR values.<br /><br />I have always assumed that this is why Oracle VARCHAR2 is not called VARCHAR - because it fails to meet the standard :)Anonymousnoreply@blogger.com