New answers tagged collation
You don't need to create a new DB cluster. You can use CREATE COLLATION in Postgres 9.1 or later. Example in the manual: To create a collation from the operating system locale fr_FR.utf8 (assuming the current database encoding is UTF8): CREATE COLLATION french (LOCALE = 'fr_FR.utf8'); Be sure to read the chapter Managing Collations in the manual to ...
Converting columns: ALTER TABLE table_name MODIFY col_name VARCHAR(100) CHARACTER SET utf8; Converting tables: ALTER TABLE table_name CONVERT TO CHARACTER SET utf8;
Another method would be to use COLLATE DATABASE_DEFAULT vs specifying the collation explicitly. DECLARE @sql NVARCHAR(MAX) DECLARE @ParamDefinition NVARCHAR(MAX) DECLARE @log NVARCHAR(MAX) ,@vCrlf CHAR(2); SELECT @log = '' ,@vCrlf = CHAR(13)+CHAR(10); SELECT @sql = ' --========================================== -- ...
You'll need to put a COLLATE hint in your join clause. Basically, choose one of the two collations, i.e. Latin1_General_CI_AS and place it after the column name that uses the other collation. SELECT @SQL = ' --========================================== -- creating the users --========================================== select db = db_name(), ...
Top 50 recent answers are included