Hello Bernd
On 2005-08-14 Bernd Eckenfels wrote:
> On Sun, Aug 14, 2005 at 03:00:40PM +0200, Christian Hammers wrote:
> > - It's no big deal as you can change the charset and collation
> > server-wide
> > vi /etc/mysql/my.cnf or with SQL commands for databases, tables,
> > single columns and even for individual SELECTs.
>
> I know that 4.1 has the alter table, it has it not for 4.0. what happens if
> you change the charset for tables which have already data in it, will it be
> converted?
I don't think that there's a need for convertion. In you case it would still
be charset "latin1" but a different collation ("latin1_german1_ci" instead of
"latin1_swedish_ci"). A collation though is only a rule that gets
applied but no change in the binary representation. Given this, yes, altering
the table affectes everything that has been stored in it before (I tried it).
> Well, I agree with the wontfix, perhaps an upstream report would be good,
> because for example there is no latin9 (iso-8859-15) charset which contains
> euro.
Yes, feel free to file a bug at dev.mysql.com. Regarding the Euro sign, latin1
is at least capable of storing it. Using ord() you can even see that latin1 is
in fact latin9 :-) (well, that's stricty spoken a bug for itself in case
anybody needs the "currency sign" :-))
bye,
-christian-
--
To UNSUBSCRIBE, email to [EMAIL PROTECTED]
with a subject of "unsubscribe". Trouble? Contact [EMAIL PROTECTED]
