MySQL 5.0 character sets
Hi, 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... So, I started learning, how MySQL 5.0 handles character sets. It is, what I think about it: 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. 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. character_set_database | latin1 It's the general database default character set, used when you create a table. No more additional meaning. ? character_set_results| latin1 It is, what the client thinks about itself, and will be used for converting character data coming from the server. character_set_server | latin1 Pass. character_set_system | utf8 Pass. Am I right? Am I miss something? I think the documentation is not clear enough in this area. 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. Can you point me to the documentation, or can you explain your experiments? Thanks, Andras -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: MySQL 5.0 character sets
Hi, Is it a so hard, or a so easy question, that nobody answers it? :) Or just should wait some more hours, and don't hurry so much? ;) Bye, Andras So, I started learning, how MySQL 5.0 handles character sets. It is, what I think about it: 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. 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. character_set_database | latin1 It's the general database default character set, used when you create a table. No more additional meaning. ? character_set_results| latin1 It is, what the client thinks about itself, and will be used for converting character data coming from the server. character_set_server | latin1 Pass. character_set_system | utf8 Pass. 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. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: MySQL 5.0 character sets
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 Goldberghttp://www.goldmark.org/jeff/ -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]