NYCPHP Meetup

[woodwort]

I think it will, depending on the charset. But if one of the accents is 
not handle properly, you could use  preg_replace, changing it to 
something that you can convert back later when you output.
have fun,
Garrett

John Nunez wrote:

> Hey Garrett,
>
> Thanks,  I can write the script but will htmlentities handle all types 
> of accented characters?
>
>
> Thanks Again,
> John
>
> On Mar 30, 2005, at 10:08 AM, woodwort wrote:
>
>> I think the easiest way is to save the excel sheet as csv.
>> Then you can create a quick script that explodes the data.
>> Run the data through htmlentities and output a SQL statement for each 
>> line.
>> I could probably organize a sample script if you need it.
>>
>> Good Luck.
>> Garrett
>>
>>
>> John Nunez wrote:
>>
>>> Hi Guys,
>>>
>>> How can I export a file from Excel which has 1000's of names that 
>>> uses German, French, Spanish accented characters to MySQL 3.23.58?  
>>> I know that MySQL 4 has unicode but upgrading this database is not 
>>> possible right now.
>>>
>>> Thanks,
>>> John Nunez
>>>
>>> _______________________________________________
>>> New York PHP Talk Mailing List
>>> AMP Technology
>>> Supporting Apache, MySQL and PHP
>>> http://lists.nyphp.org/mailman/listinfo/talk
>>> http://www.nyphp.org
>>>
>>>
>>
>>
>> _______________________________________________
>> New York PHP Talk Mailing List
>> AMP Technology
>> Supporting Apache, MySQL and PHP
>> http://lists.nyphp.org/mailman/listinfo/talk
>> http://www.nyphp.org
>>
>
> _______________________________________________
> New York PHP Talk Mailing List
> AMP Technology
> Supporting Apache, MySQL and PHP
> http://lists.nyphp.org/mailman/listinfo/talk
> http://www.nyphp.org
>
>