Re: mysql 4.0 to 4.1 migration and charset problems

2005-07-15 Thread Gleb Paharenko
Hello. It is not clear from you message what's the problem. From your calculations I can see that the length of int field in a flat file row (BTW please send a piece of your file) is different in mysqldump programs with different versions? How is the length of integer fields related to cha

Re: mysql 4.0 to 4.1 migration and charset problems

2005-07-14 Thread Vivian Wang
the version is 4.1.12. show variables like this, | character_set_client| latin1 | character_set_connection| latin1 | character_set_database | latin1 | character_se

Re: mysql 4.0 to 4.1 migration and charset problems

2005-07-12 Thread Gleb Paharenko
Hello. > Any possible problems with this approach? It is good, if it solved your problems. >> So it works for me. > > I've ended doing this in a different way. I've created a patch which forces= > a=20 > file to be read - /etc/mysql/mysql-client.conf (which is the same as .my.cn

Re: mysql 4.0 to 4.1 migration and charset problems

2005-07-11 Thread Arkadiusz Miskiewicz
On Monday 11 of July 2005 16:24, Gleb Paharenko wrote: > Hello. > > I've tested your solution. It doesn't work for users which have SUPER > privilege. This mentioned at: > http://dev.mysql.com/doc/mysql/en/server-system-variables.html > > However, it works with with ordinary users which don't hav

Re: mysql 4.0 to 4.1 migration and charset problems

2005-07-11 Thread Gleb Paharenko
Hello. I've tested your solution. It doesn't work for users which have SUPER privilege. This mentioned at: http://dev.mysql.com/doc/mysql/en/server-system-variables.html However, it works with with ordinary users which don't have SUPER privilege. Here are pieces of my my.cnf (the init_co

Re: mysql 4.0 to 4.1 migration and charset problems

2005-07-11 Thread Arkadiusz Miskiewicz
On Thursday 07 of July 2005 00:16, Gleb Paharenko wrote: > Hello. > > > For a pity, I could give explanations only for your query about > selecting @@global.xxx variables. I think server returns correct > results, because you're selecting global variables, while > character_set_client, character_se

Re: mysql 4.0 to 4.1 migration and charset problems

2005-07-06 Thread Gleb Paharenko
Hello. For a pity, I could give explanations only for your query about selecting @@global.xxx variables. I think server returns correct results, because you're selecting global variables, while character_set_client, character_set_connection, character_set_results are session variables. A

mysql 4.0 to 4.1 migration and charset problems

2005-07-06 Thread Arkadiusz Miskiewicz
Hi, I have mysql 4.0 db with configuration: set-variable = default-character-set=latin2 set-variable = character-set=latin2 now I'm trying to migrate to mysql 4.1.12 My current config is: character-set-server=latin2 collation-server=latin2_general_ci The problem is connection/reply/client-chara