NYCPHP Meetup

[John Nunez]

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
>