"Ryan Stille" <rps@stripped> wrote on 03/09/2006 09:59:32 AM:
> Are my emails not coming through? Or is this question way too 'newbie'
> and no one wants to touch it?
> Ryan Stille wrote:
> > I'm still hoping someone can else can share their input on this.
> > What do other people usually do as far as the collation setting?
> > Thanks,
> > -Ryan
> > Ryan Stille wrote:
> >> When we migrated to MySQL from MS SQL, I left everything set to the
> >> default as far as collations - latin1_swedish_ci.
> >> This was based on digging through the manual and google. But now I am
> >> migrating the application to a newer version of ColdFusion and am
> >> running into some issues with charsets on some ColdFusion functions.
> >> I am wondering if my database charset has anything to do with it.
> >> What do other people usually do as far as the collation setting?
> >> We are in the US, but do have a few sites that make use of German
> >> and Spanish characters.
> >> Thanks,
> >> -Ryan
I don't think that your question was too newbie. I believe that within the
world of MySQL that changing charsets and collations is still something of
a dark art. Not many users need something other than the default settings
and those that do experiment with the various charsets and collations
until they find one that works for them.
There have been frequent posts on this list looking for help in setting up
a character set or trying to resolve why certain characters no longer
"appear" as they were when they went into the database. The basic thing
to remember is that each and every communications channel can have it's
OWN charset setting. If you are pushing data in using utf-8 and you are
pulling data out through a connection using UCS-2, you may run into a few
translation errors (that was just an example, I don't know if they are
incompatible or not)
I think that the default charset and collation covers most or all of the
european alphabets so you may not need to use anything but the defaults
for English, Spanish, Italian, Portuguese, French, German, and the Nordic
languages (I can't name them all, sorry to those who live there). I have
to admit that I haven't had to delve deeply into this subject so I cannot
speak from deep experience but that's basically what I have gathered by
lurking on the other posts dealing with this topic.
Unimin Corporation - Spruce Pine