Forum: Typo Mysql Collation Questions

Announcement (2017-05-07): www.ruby-forum.com is now read-only since I unfortunately do not have the time to support and maintain the forum any more. Please see rubyonrails.org/community and ruby-lang.org/en/community for other Rails- und Ruby-related community platforms.
Db2e18e91153c170999e1711892bb9f8?d=identicon&s=25 Jason Froderman (Guest)
on 2006-03-31 04:19
(Received via mailing list)
I've noticed that the schema in typo has collation of: latin1_swedish_ci

I don't know much about collation except for the ability to sort
differently by specifying "COLLATE"...

Is there any reason (or reason against) changing the collation from
swedish to general?  What's the usual collation chosen for the United
States or the UK?

If it's a worthy enough idea of changing, is there an easy way to
change collation recursively...I know you can apply a collation change
to a db, table, and then table fields...doing all that separately would
take a lot of work.

Thanks for the info,
Jason
Dc3f3775a7d03ba1be8958aaee881d6b?d=identicon&s=25 Scott Laird (Guest)
on 2006-03-31 16:29
(Received via mailing list)
To the best of my knowedge, we aren't explicitly setting any
characterset or language settings.  Look at db/schema.mysql.sql.  So,
I'd guessthat your Mysql is defaulting to Swedish for some reason.  I
don'tknow enough about Swedish to know if its collation settings
aredifferent then English's in any meaningful way.  I know that Dutch
isdifferent (ij), but I'm lost WRT most other European languages.

Scott
On 3/30/06, Jason Froderman <froderman@gmail.com> wrote:> I've noticed
that the schema in typo has collation of: latin1_swedish_ci>> I don't
know much about collation except for the ability to sort> differently by
specifying "COLLATE"...>> Is there any reason (or reason against)
changing the collation from> swedish to general?  What's the usual
collation chosen for the United> States or the UK?>> If it's a worthy
enough idea of changing, is there an easy way to> change collation
recursively...I know you can apply a collation change> to a db, table,
and then table fields...doing all that separately would> take a lot of
work.>> Thanks for the info,> Jason>>
_______________________________________________> Typo-list mailing list>
Typo-list@rubyforge.org>
http://rubyforge.org/mailman/listinfo/typo-list>
This topic is locked and can not be replied to.