MySQL Forums :: Character Sets, Collation, Unicode :: set names 'utf8'


Advanced Search

set names 'utf8'
Posted by: danielmcbrearty ()
Date: September 29, 2005 02:30AM

When I set up a table in 4.1 and give it a default charset of utf8, then enter valid utf8 values, mysql alters some of those values into non-utf8 values without telling me.

The cure is to issue the "set name 'utf8'" instruction at the start of the session.

Unless someone can explain to me some good reason why it behaves like this, this is a pretty nasty BUG.

Options: ReplyQuote


Subject Views Written By Posted
set names 'utf8' 66015 danielmcbrearty 09/29/2005 02:30AM
Re: set names 'utf8' 20897 danielmcbrearty 09/30/2005 02:54AM
Re: set names 'utf8' 47175 Shuichi Tamagawa 09/30/2005 11:45AM
Re: set names 'utf8' 14982 danielmcbrearty 10/04/2005 02:52PM
Re: set names 'utf8' 14901 Suat Ural 11/20/2007 06:04AM
Re: set names 'utf8' 11835 Banzai 301 02/14/2009 09:18AM


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.