Entering foreign characters into MySQL
| From: | php @ net mines | Date: | Tue, 13 Sep 2005 17:02:49 +0000 |
| Subject: | Entering foreign characters into MySQL | ||
| References: | 1 2 3 | Groups: | php.general |
| Request: | Send a blank email to php-general+get-222273@lists.php.net to get a copy of this message | ||
Hi all
I have a bulgarian/spanish excel file that I have to import to a mysql database.
Since I can't save it as csv without replacing the foreign chars with (???????) I saved it as unicode text. Next, I thought I would replace the (\t) with (;) and all the foreign chars with the &#xxx;.
The problem is that I still get (????) instead of the &#xxx;&#xxx;&#xxx;&#xxx;&#xxx; word.
Can anyone help
Thanks
Mario