RE: Converting database and its tables to UTF-8

: Gabriel PREDA [mailto:[EMAIL PROTECTED] Sent: Tuesday, February 14, 2006 6:30 PM To: mysql@lists.mysql.com Cc: Peter Lauri Subject: Re: Converting database and its tables to UTF-8 Hi Peter, That will be a lot of work ! 1. First make a back-up... it's always a good ideea ! 2. For every

Re: Converting database and its tables to UTF-8

Hi Peter, That will be a lot of work ! *1.* First make a back-up... it's always a good ideea ! *2.* For every table in the database alter String Types into BINARY string types that means: - *(VAR)CHAR(M)* will become *(VAR)**CHAR(M) BINARY* or *(VAR)**BINARY(M)* - *TINYTEXT, TEXT, MEDIUMTEXT,

Converting database and its tables to UTF-8

Hi, I have a database with around 40 tables that needs to be converted to UTF-8 to support multi languages. What is the best procedure to do this? And is it any way to change the default charset to UFT-8 so tables by default will become UFT-8? And can I have one table with different fi

Converting database

Dear Members! I have a problem at my work: I must to convert a Corel-Paradox table (.db) to MySQL database ? How can I to do this ??? Thanks! - Before posting, please check: http://www.mysql.com/manual.php (the manual

Re: converting database as text

Hi Alexandrino. Have you tried % mysqldump db_name [table_name] ? Try it -- Sherzod Ruzmetov [EMAIL PROTECTED] http://www.ultracgis.com/sherzodR Sent on Jul 3 by Alexandrino B. Arvesu to [EMAIL PROTECTED] alex> Hi, alex> alex> Is there a way of converting mySQL database to a readable

converting database as text

Hi, Is there a way of converting mySQL database to a readable text file? What I mean is not importing the data via myODBC from another client, but by issuing a command to the Unix prompt (mySQL server itself) then it will generate a readable text file. Thanks in advance. Alex