NYCPHP Meetup

[Chris Bielanski]

Alternately, you could try urlencode() on your data before insertion. It
may not work perfectly, but I think it's worth a shot.

Thanks,
Chris Bielanski
Web Programmer, 
International Trademark Association,
655 Third Avenue, 10th Floor
New York, NY 10017-5617 USA
+1 (212) 642-1745, f: +1 (212) 768-7796
mailto:cbielanski at inta.org, www.inta.org  
INTA -- 125 Years of Excellence
 

> -----Original Message-----
> From: talk-bounces at lists.nyphp.org 
> [mailto:talk-bounces at lists.nyphp.org] On Behalf Of woodwort
> Sent: Wednesday, March 30, 2005 10:08 AM
> To: NYPHP Talk
> Subject: Re: [nycphp-talk] How can I import accented 
> characters into MySQL?
> 
> 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
>