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/
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]