got it cocoa was showing everything in the mysql as utf8, but the tables themselves were latin1
:-) wicked, I now have the great job of turning it all back, setting it to not create as Latin1 in the future, check all the data thanks for your help everyone, not a django problem, an mysql one On 29/08/2007, Matt Davies <[EMAIL PROTECTED]> wrote: > > Hi Jarek > > Yep, got that line in my.cnf, my cocoa Show Variables are all utf8. > > curl tells me it's utf8, request.meta tells me it's utf8, bit it really > doesn't look like it is utf8 > > any more suggestions anyone? > > On 29/08/2007, Jarek Zgoda <[EMAIL PROTECTED]> wrote: > > > > > > Matt Davies napisaĆ(a): > > > > > yeah mate, everything I can think of is set to utf-8 and unicode as > > > explained here > > > > > > How did you get that character into the database? > > > > > > Did you add it to a web form and put it in like that? > > > > > > If so, did you type the character, or did you copy and paste it from > > > somewhere else? > > > > > > Sorry to be a pain mate, but it'll really help me out if I can work > > out > > > whats going on here. > > > > > > Interestingly enough only those two characters mess up, the others > > with > > > circumflexes are fine. > > > > Are you sure your MySQL client sets proper charset on connection? From > > the docs at > > > > http://www.djangoproject.com/documentation/databases/#connecting-to-the-database > > - check if the last line of example MySQL config file is in place. From > > your description it looks that the client encoding is set to latin1. > > > > -- > > Jarek Zgoda > > Skype: jzgoda | GTalk: [EMAIL PROTECTED] | voice: +48228430101 > > > > "We read Knuth so you don't have to." (Tim Peters) > > > > > > > > > --~--~---------~--~----~------------~-------~--~----~ You received this message because you are subscribed to the Google Groups "Django users" group. To post to this group, send email to django-users@googlegroups.com To unsubscribe from this group, send email to [EMAIL PROTECTED] For more options, visit this group at http://groups.google.com/group/django-users?hl=en -~----------~----~----~----~------~----~------~--~---