Top "Collate" questions

Is a clause that can be applied to a database definition or a column definition to define the collation, or to a character string expression to apply a collation cast.

T-SQL Table variable with case sensitive columns - collate SQL_Latin1_General_CP1_CS_AS

Is it possible to have collate SQL_Latin1_General_CP1_CS_AS in table variable columns' definitions? The reason I …

Read More
sql-server tsql table-variable collate
How can I convert "SQL_Latin1_ General" Collate Using an SSIS Package?

We've just noticed 2 of our servers have been set up using SQL_Latin1_General_CP1_CI_AS and Latin1_General_…

Read More
sql sql-server-2008 ssis collate
PostgreSQL 9.1 using collate in select statements

I have a postgresql 9.1 database table, "en_US.UTF-8": CREATE TABLE branch_language ( id serial NOT NULL, name_language character …

Read More
postgresql collate
How should I use COLLATE in Hibernate Query

I'am trying to use COLLATE statement in a Hibernate SQL query but, it doesn't recognize the statement. CONSULTA: FROM Articulos …

Read More
java sql hibernate collate
Cant insert utf8 characters on mysql (with utf8 collation, charset and nameset)

im facing a really stressing problem here.. i have everything in UTF-8 , all my DB and tables are utf8_general_…

Read More
php mysql utf-8 character-encoding collate