On Oct 28, 2005, at 1:06 AM, BÁRTHÁZI András wrote:
> I'm new on this list, so a very short intro about me: I'm Andras
> Barthazi, a Hungarian web developer. I like MySQL very much, I'm
> using it since 3.x versions, so I think I know it very well. But...
I'm new to everything, but I can tell you what I think that manual says.
> character_set_client | latin1
>
> This is, what the client thinks about itself, determined from the
> environment. It will be used for autoconverting character data sent
> from the client.
It is what the client tells the server about the queries that the
client sends.
> character_set_connection | latin1
>
> This is, what the client thinks about the server, but I'm not sure,
> how it will be determined, and what exactly is it for. As the
> documentation says, it will be used for autoconverting character
> data sent to the server.
It is what the server uses internally. The server will convert
queries from character_set_client to character_set_connection
> character_set_database | latin1
>
> It's the general database default character set, used when you
> create a table. No more additional meaning. ?
That is my guess.
> character_set_results | latin1
>
> It is, what the client thinks about itself, and will be used for
> converting character data coming from the server.
When the server sends results to the client it will send the results
in character_set_results. That is the server will convert from
character_set_connection to character_set_results when sending results.
> character_set_server | latin1
>
> Pass.
Fogolmam sincs. (I can't figure it out from the documentation either).
> character_set_system | utf8
>
> Pass.
Sincs (nor here).
> And another strange thing I found: you can set the table's
> (default) character encoding, but I see no effect. The table data -
> of course - won't be converted (that's another alter table
> command), the results I got won't be changed - so I don't know,
> what exactly default table character set is good for.
I've also been having some difficulty with this. I recommend using
utf8 for everything, unless the window in which you run the client
can't handle utf8.
Remember, those accent marks matter. After all
Szárba szökik
just isn't the same without them.
Minden jót.
-j
--
Jeffrey Goldberg http://www.goldmark.org/jeff/
