Vertica default collation ?
I have the following table in MYSQL that I need to move to Vertica.
CREATE TABLE
report_episode_detail
(
Filter_ID INT,
Member_ID VARCHAR(50) COLLATE utf8_bin,
Master_Episode_ID VARCHAR(255) COLLATE utf8_bin
)
ENGINE=InnoDB DEFAULT CHARSET=latin1 DEFAULT COLLATE=latin1_swedish_ci;
DO I need to worry in Vertica to COLLATE the fields being the fact that that default is default en_US@collation=binary?
As shown here
Locale specifies the user's language, country, and any special variant preferences, such as collation. Vertica uses locale to determine the behavior of certain string functions. Locale also determines the collation for various SQL commands that require ordering and comparison, such as aggregate GROUP BY and ORDER BY clauses, joins, and the analytic ORDER BY clause.
The default locale for a Vertica database is en_US@collation=binary (English US). You can define a new default locale that is used for all sessions on the database. You can also override the locale for individual sessions. However, projections are always collated using the default en_US@collation=binary collation, regardless of the session collation. Any locale-specific collation is applied at query time.