Search the web
Sign In
New User? Sign Up
DatabaseTemplateLibrary · The Database Template Library
? Already a member? Sign in to Yahoo!

Yahoo! Groups Tips

Did you know...
Want your group to be featured on the Yahoo! Groups website? Add a group photo to Flickr.

Best of Y! Groups

   Check them out and nominate your group.
Having problems with message search? Fill out this form to ensure your group is one of the first to be migrated to the new message search system.

Messages

  Messages Help
Advanced
UTF8 strings   Message List  
Reply | Forward Message #2461 of 2478 |
I have an XML which I parse and insert data into a MySQL database, the strings
are in utf8 format, and although I've setup the columns to be utf8 the strings
are stored verbatim, i.e. I see the utf8 escape sequences in the database (using
SQLyog). Before using DTL we just had php put stuff in the database, and that
works fine, showing the correct characters.

Ideas?
/Rob





Thu Jun 25, 2009 6:57 am

robert_bielik
Offline Offline
Send Email Send Email

Forward
Message #2461 of 2478 |
Expand Messages Author Sort by Date

I have an XML which I parse and insert data into a MySQL database, the strings are in utf8 format, and although I've setup the columns to be utf8 the strings...
Robert Bielik
robert_bielik
Offline Send Email
Jun 25, 2009
6:58 am

Maybe you could let MySQL convert it to utf8: http://dev.mysql.com/doc/refman/5.0/en/charset-convert.html But of course its better, if you don't have to...
Jens Weller
JensWeller@...
Send Email
Jun 25, 2009
2:34 pm
Advanced

Copyright © 2009 Yahoo! Inc. All rights reserved.
Privacy Policy - Terms of Service - Guidelines - Help