Page 2 of 2

Posted: Tue Jan 09, 2007 6:15 pm
by georgeoc
Is that true that the fudging is only needed on creating the tables? Not every time the app opens a connection to a database?

I'm happy to keep all user admin control panel stuff to ASCII - no problem with that. My worries are when I come to importing an email from a POP mail box, for example, and converting it into a PDF, a phpBB forum post, or whatever. That's the kind of challenge I'm talking about. Although, from your post it seems like it may not be as impossible as I thought.

Posted: Tue Jan 09, 2007 6:24 pm
by Ambush Commander
There's a separate set of fudging that happens while creating the database, sorry. Early versions of MySQL don't support having their character encoding specified in CREATE table calls.

Posted: Tue Jan 09, 2007 6:26 pm
by georgeoc
But when I connect to the db each time, to add or retrieve data? Do I need to specify UTF-8 when connecting?

Posted: Tue Jan 09, 2007 6:28 pm
by Ambush Commander
Yes, unless, as I mentioned before, you're storing the UTF-8 data in a binary column. You could even use varchar with binary.

Posted: Tue Jan 09, 2007 6:29 pm
by georgeoc
OK. Thanks so much for your help and patience. Wish me luck!

Posted: Wed Jan 10, 2007 3:07 am
by Maugrim_The_Reaper
Good luck!