"Ryan Stille" <[EMAIL PROTECTED]> 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
