Re: Can someone please clarify this for me?
Posted by: Trudy Pelzer
Date: December 09, 2005 05:18PM

Hi Rudi,

The purpose of specifying a collation for the character columns
in a table is to guarantee that data in those columns will always
be collated using that collation whenever you sort or compare
them.

For example, suppose you have some data that should always
be treated as German data, but most of your data should not.
You have two choices: you can create your table for "german"
data as always, and whenever you sort or compare add a
COLLATE clause to your SQL statement. Or you can create the
table (or specific columns) using the collation directly in the
definition; then, whenever you sort or compare with those
columns, you won't have to use the COLLATE clause because
MySQL will automatically treat the values as "german", based
on your table definition.

Trudy Pelzer, Engineering Project Manager
MySQL AB, www.mysql.com

Are you MySQL certified? www.mysql.com/certification

Options: ReplyQuote


Subject
Views
Written By
Posted
2425
December 06, 2005 12:55PM
Re: Can someone please clarify this for me?
1688
December 09, 2005 05:18PM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.