Archives of the TeradataForum

Message Posted: Thu, 14 Apr 2016 @ 14:27:28 GMT

	<Prev	Next>		<<First	<Prev	Next>	Last>>

Barring using NOT CASESPECIFIC, can't see it does anything with accents in the TD docs .You could use SQL Server, sorry, with a database set to a collation of CI_AI which is case insensitive/accent insensitive.

I tried this with variations on CS and NOT CS in the WHERE clause to no avail to test:

     CREATE VOLATILE TABLE accent_test
     (
      COL1 CHAR(10) CHARACTER SET LATIN NOT CASESPECIFIC
     ,COL2 CHAR(10) CHARACTER SET LATIN NOT CASESPECIFIC
     )
     ON COMMIT PRESERVE ROWS
     ;

     INSERT INTO accent_test VALUES ('E','?'); -- ? = Windows, ALT 0200

     SELECT *
       FROM accent_test
     ;

     SELECT *
       FROM accent_test
      WHERE col1 (NOT CS) = col2 (NOT CS)
     ;

Otherwise you're probably looking at a UDF. If you build one, do share! :-)

	<Prev	Next>		<<First	<Prev	Next>	Last>>