Mysql 5.1.38, outfile of type xls created with utf8
Posted by: miriam kugel
Date: November 15, 2009 07:23AM

Hello,Thank

I have a stored procedure that creates an outfile:

into outfile 'd:\\fullExcell.xls'
character set utf8
fields TERMINATED BY ','
ENCLOSED BY '"' LINES TERMINATED BY '\r\n';

The outfile is OK but when openning it with Microsoft excell I have to specify the character set again, if not then the hebrew text cannot be read.
The 2003 excell has no option to import a file with character set utf8.
Please advise, how can I solve the problem.

Options: ReplyQuote


Subject
Views
Written By
Posted
Mysql 5.1.38, outfile of type xls created with utf8
4780
November 15, 2009 07:23AM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.