Lost your password?

Blogs about: Collation

Featured Blog

SQL – Cannot resolve the collation conflict between "SQL_Latin1_General_CP1_CI_AS" and "Latin1_General_CI_AS"

Rob Bamforth wrote 3 days ago: This error occurs when trying to join two databases that have different collation. you can change th … more →

Tags: SQL, Collate, Latin1_General_CI_AS, SQL_Latin1_General_CP1_CI_AS

Changing collation of columns in a database

cfeckardt wrote 4 days ago: Ever run into problems with different tables having different collations? Here’s a short scrip … more →

Tags: SQL

SQL – change the collation of a database1 comment

Rob Bamforth wrote 1 week ago:   The following code shows how to alter the collation of a database. The database must be set t … more →

Tags: SQL, SQL Server 2005

Insert Collation Tip SQL Server

robertoerazo wrote 1 month ago: Hola a todos, quiero compartir con Ustedes algo que parece trivial, pero que en muchos casos no se t … more →

Tags: Noticias, Cómo hacer, HOW TO?, insert, Microsoft, select, SQL Server 2005

Data collection

andrewbassett wrote 1 month ago: Data collection what is it? How is it done? You have a clubcard? Tesco’s now makes a fortune f … more →

Tags: Collection, Data, Information, Product, Service, Shared

How to Change the Collation on All Tables in MySQL

Sokunluck wrote 4 months ago: I have worked so hard just to search for any clue that can help me solve one problem which is changi … more →

Tags: Others, mysql, All Table, php

Changing Collation of SQL server Database

Manpreet Singh wrote 4 months ago: As we all know that collation is a important part of Sql server storage engine. The collation define … more →

Tags: administration

MSSQL Collation for GP

istewart wrote 5 months ago: http://dynamicsgpblogster.blogspot.com/2008/08/microsoft-dynamics-gp-and-sql-server.html … more →

Tags: MSSQL, binary, Case-Insensitive, Microsoft Dynamics GP, sort order, SQL

Collation

n2739178 wrote 5 months ago: Collation refers to a set of rules that determine how data is sorted and compared. Character data is … more →

Tags: Database Core Knowledge

Where to begin?9 comments

Carin wrote 6 months ago: Welcome to the blog! Details about me and about the purpose of the blog are on the aptly-named About … more →

SQL Collations & Case Sensitive Searches

Vijay Dev wrote 7 months ago: I got a question recently from a friend about doing case sensitive searches in SQL and I did not kno … more →

Tags: Programming, technology, case-sensitivity, Databases, Indexes, MS SQL, mysql, PostgreSQL, queries

What I Learned Studying MySQL and the SQL Language

spartacus wrote 7 months ago: CHAR and TEXT fields Any text field that yo expect to use for values longer than 255 characters you … more →

Tags: IT - Computers - Internet, SQL, mysql, myisam, innodb, CHAR data type, VARCHAR data type, TEXT data type, character set

Fingers in the [SQL] mud - Collation inconsistencies

niklashedin wrote 8 months ago: Hi Dear Reader, For my first post, I would like to throw you a nugget. It’s not any fancy high-level … more →

Tags: SQL, Script

Unicode coming to PHP 63 comments

Joe Devon wrote 9 months ago: The move from PHP 5 to PHP 6 will be a painful one. But once it’s done, I hope that it will be … more →

Tags: mysql, php, charset, Unicode, Yahoo

SQL Collation Issues

smartsoftnz wrote 9 months ago: Collation can be specified on Server Instance, Database, Table & Column level.  If you try to jo … more →

Tags: SQL

Now Thats the Liberal Party I love to distrust

ronsrantsravesandreviews wrote 9 months ago: Well Well Well isn’t that Michael Ignatieff and his Liberal party cronies a bunch of sneaky li … more →

Tags: rants, Raves, Reviews, Ron, Conservative, Stephen Harper, Bob Rae, Dominic LeBlanc, democracy

windows versus sql collation

vinuthan wrote 11 months ago: There was a question posted by my friend as to which collation to select for a column, whether the “ … more →

Tags: SQL, windows collation, SQL Collation, Collate, window collation

Search and Replace in SQL Server

tgrignon wrote 1 year ago: And now a chance to wax programmatic about the replace feature in SQL Server. Opening up a table and … more →

Tags: Miscellany, replace, Search and Replace, SQL Server

How to make a case sensitive comparision of strings in SQL Server 2 comments

Imran Akram wrote 1 year ago: String in SQL Server are by default case insensitive. That means that “SQL” is equivalen … more →

Tags: SQL Server 2005, SQL Server, case sensitive string comparison, casesenstive comparison, SQL_Latin1_General_CP1_CS_AS, Collate, password comparison in SQL Server


Have your say. Start a blog.

See our free features →

Related Tags
All →

Follow this tag via RSS