• Open Menu Close Menu
  • Apple
  • Shopping Bag
  • Apple
  • Mac
  • iPad
  • iPhone
  • Watch
  • TV
  • Music
  • Support
  • Search apple.com
  • Shopping Bag

Lists

Open Menu Close Menu
  • Terms and Conditions
  • Lists hosted on this site
  • Email the Postmaster
  • Tips for posting to public mailing lists
Help with MySQL and Unicode (UTF8)
[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

Help with MySQL and Unicode (UTF8)


  • Subject: Help with MySQL and Unicode (UTF8)
  • From: Dev WO <email@hidden>
  • Date: Thu, 17 Jun 2004 21:38:54 +0200

Hi all,
This may not be a WO direct question, but maybe someone could help me anyway, or at least point me to something I should have found before posting;)


I want to work only in UTF8, so I know how to do it in WO (it should be easier though), but my main problem is with the database. I'm using MySQL provided with Panther server (4.0.16 I think) on the server and it seems this version doesn't support UTF8...
So I'm actually trying to install the 4.1.2-Alpha on a local machine, and even if everything looks good with MySQL's package, I have some weird things happening:
-the startup item doesn't work, I don't even get a message in any log. It's the same if I leave it in the default location (/Library/StartupItems/) or in the system's one (/System/Library/StartupItems)
NB: I can start the MySQL server from the command line, but it won't be an option to do it on the server every time we need to reboot.
-If I don't set a password for the root account, everything seems to work correctly, I can use CocoaMySQL and phpMyAdmin to administer the database, but if I set a root password, both phpMyAdmin and CocoaMySQL can't connect anymore (of course I changed the conf file of phpMyAdmin, and add the password for the root account in CocoaMySQL;))


So did anyone have any success with MySQL 4.1 on OS X (start at boot, CocoaMySQL and/or phpMyAdmin can connect)?
Or is there another way to make the database provided with Panther (4.0.16) works with UTF8?


I could try to move to PostgreSQL for example, but will it resolves my UTF8 problem, and what would be the benefits for moving to it? I may move to another database in the futur, but for now I have to stick with one of the "free" option.

Thanks a lot for your support, hope we'll get some great news about WO at WWDC;)

Sincerely,

Xavier
_______________________________________________
webobjects-dev mailing list | email@hidden
Help/Unsubscribe/Archives: http://www.lists.apple.com/mailman/listinfo/webobjects-dev
Do not post admin requests to the list. They will be ignored.


  • Prev by Date: EODisplayGroup
  • Next by Date: Re: Inheritance from separate model file
  • Previous by thread: Re: EODisplayGroup
  • Next by thread: Packaging a WO Application
  • Index(es):
    • Date
    • Thread