If I use iconv to convert mysql dump data file with some blob field then blob binary data will be corrupted ?

Hi, This my script to convert latin1 database to utf8 : $ mysqldump --user=root --password=password --host=mybox mydatabase -- default-character-set=latin1 mydatabase.latin1.sql$ mysqldump -- user=root --password=password --host=mybox mydatabase --default-character- set=latin1

Re: If I use iconv to convert mysql dump data file with some blob field then blob binary data will be corrupted ?

I've break line misteak in my previous message, this is the fix : $ mysqldump --user=root --password=password --host=mybox mydatabase -- default-character-set=latin1 mydatabase.latin1.sql$ mysqldump -- user=root --password=password --host=mybox mydatabase --default-character- set=latin1

Re: If I use iconv to convert mysql dump data file with some blob field then blob binary data will be corrupted ?

Le Tue, 23 Dec 2008 14:42:40 +, KLEIN Stéphane a écrit : Hi, This my script to convert latin1 database to utf8 : $ mysqldump --user=root --password=password --host=mybox mydatabase -- default-character-set=latin1 mydatabase.latin1.sql$ mysqldump -- user=root --password=password

Re: If I use iconv to convert mysql dump data file with some blob field then blob binary data will be corrupted ?

Le Tue, 23 Dec 2008 15:33:34 +, KLEIN Stéphane a écrit : Le Tue, 23 Dec 2008 14:42:40 +, KLEIN Stéphane a écrit : Hi, This my script to convert latin1 database to utf8 : $ mysqldump --user=root --password=password --host=mybox mydatabase -- default-character-set=latin1

Re: How can I do something like this SELECT MAX(col1, col2, col3) FROM mytable ORDER BY MAX(col1, col2, col3); ?

2007/6/13, Ricardas S [EMAIL PROTECTED]: ops again you probably needed just select greatest(col1,col2,col3) from t order by 1 Thanks, it's work very well. best regards -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:

How can I do something like this SELECT MAX(col1, col2, col3) FROM mytable ORDER BY MAX(col1, col2, col3); ?

Hi, I would like do something like : SELECT MAX(col1, col2, col3) FROM mytable ORDER BY MAX(col1, col2, col3); I know this syntax is wrong but I would like get a solution to this stuff. Thanks for your help. Stephane -- MySQL General Mailing List For list archives:

Re: How can I do something like this SELECT MAX(col1, col2, col3) FROM mytable ORDER BY MAX(col1, col2, col3); ?

2007/6/13, Ricardas S [EMAIL PROTECTED]: Ops, small mistake, shoud be MAX((col1*(MAX_VALUE_OF_COL2+1)+col2)*(MAX_VALUE_OF_COL3+1)+col3) Sorry, my question is ashamed. Example, I've this row : Col1 | Col2 | Col3 1 | 5 | 8 6 | 2 | 4 12| 13 | 6 After my query,

Are there any tools to get diff (alter commands) between tow tables ?

Hello, I wonder if there are any tools to do a diff between two tables struture to result alter command to convert table A structure to table B structure ? Thanks for your information. Stephane -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:

Re: Are there any tools to get diff (alter commands) between tow tables ?

2007/3/19, Martijn Tonies [EMAIL PROTECTED]: Hi, I wonder if there are any tools to do a diff between two tables struture to result alter command to convert table A structure to table B structure ? Yes, our tool Database Workbench includes a so-called Schema Compare tool which allows you to

Re: Can I set many IP address with bind-address ? If not, how can do same thing ?

2006/10/4, Dominik Klein [EMAIL PROTECTED]: You can only specify one IP address to bind to. If you omit this option, mysqld will bind to all addresses on the machine. If this is not what you want, you could block mysql-access with a packet filter for the IP addresses you do not want to bind

Can I set many IP address with bind-address ? If not, how can do same thing ?

Hi, Can I set many IP address with bind-address ? If not, how can do same thing ? In documentation, I read this : ''' -bind-address=IP The IP address to bind to. ''' They don't say if I can use comma to separate two or many IP. Thanks for your help, Stephane -- MySQL General Mailing List