Hi, Two way, depending on size of Your data ...
- programming if data is more than 64MB - best way - export MS SQL 7 to MS Access and import MS Access to MySQL (my experience is only char.data, no image in blob or other things like this) Best regards Peter W Rasmussen ----- Original Message ----- From: "Dale Goolcharan" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Friday, February 13, 2004 1:07 AM Subject: Mysql issues. > Hi, > I am currently migrating data DIRECTLY from a microsoft sql server 7 > database into a mysql database. The sql database supports strings in > different languages(Japanese French, spanish and so on). The sql 7 database > has been setup to support unicode. > > 1. How do I create a databese to support unicode in mysql. I read the doc. > on mysql.com and it specified about using the database unicode parameter or > setting unicode at the column level. How can I perform this at the command > line. I will prefer to use the Database option. > > 2. The above migration only works if I use varchar(255) instead of blob > datatype. I need in mysql to have columns in tables that will support up to > 5000 charaters for string data. Sql 7 complains that it does not support > blob upon exporting data into mysql directly. All other datatypes work. > How do I solve this and does mysql allow a dataype that can accept string > data up to 5000 characters. > > I am new to mysql. Any help will be appreciated. > > Thank you. > Dale Goolcharan. > > _________________________________________________________________ > MSN 8 helps eliminate e-mail viruses. Get 2 months FREE*. > http://join.msn.com/?page=features/virus&pgmarket=en-ca&RU=http%3a%2f%2fjoin.msn.com%2f%3fpage%3dmisc%2fspecialoffers%26pgmarket%3den-ca > > > -- > MySQL General Mailing List > For list archives: http://lists.mysql.com/mysql > To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED] > > -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
