List:General Discussion« Previous MessageNext Message »
From:SGreen Date:March 9 2006 4:41pm
Subject:RE: Charset questions
View as plain text  
"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
> 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.

Shawn Green
Database Administrator
Unimin Corporation - Spruce Pine

Charset questionsRyan Stille3 Mar
RE: Charset questionsRyan Stille8 Mar
RE: Charset questionsRyan Stille9 Mar
  • RE: Charset questionsSGreen9 Mar
    • Re: Charset questionsGabriel PREDA10 Mar