MySQL Forums :: Newbie :: Will changing Default Collation on live BSD box cause any problem?


Advanced Search

Will changing Default Collation on live BSD box cause any problem?
Posted by: none given ()
Date: November 28, 2009 04:13AM

Hi,

dumb newbie's question seemingly unasked on the forum ...

Will changing Default Collation on a live BSD box cause any problem?

I am dealing with MySQL 5.0.87 running on AMD64 box with FreeBSD 6.2 installed. The server also has CPANEL 11.24.5 and serves shared hosting.

Unfortunately, when installed, default collation was set to:

latin1_swedish_ci - which causes some problems with various non-English languages.

I would prefer to set the default to something like:

utf8_unicode_ci - (unicode or bin, I am prepared to take your advice).

• Will changing the 'Default Collation' cause any problems? Would it require downtime, a re-compilation etc?

Yes, I have read the docs but would prefer real work experience.

---------------------
Just out interest ... is 'latin1_swedish_ci' some patriotic gesture on behalf of the original developers and would Sun be interested in changing that default to something more universal? It obvious causes pain and effort globally ...

Thanks, as ever, in advance.



Edited 2 time(s). Last edit at 11/28/2009 04:18AM by none given.

Options: ReplyQuote


Subject Written By Posted
Will changing Default Collation on live BSD box cause any problem? none given 11/28/2009 04:13AM
Re: Will changing Default Collation on live BSD box cause any problem? Rick James 11/29/2009 03:55PM


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.