How to get unicode into MySQL from Cocoa

[markpatterson]

Hi, I am working on an app that would suit the international market. I'm getting into MySQL at present. It seems to be suitable, since it claims to support unicode from 4.1: http://dev.mysql.com/doc/mysql/en/Charset-Unicode.html

Since the Cocoa app kit supports unicode, I need to know the next step: how do I store and retrieve and query on unicode strings in the database? Which API is appropriate? Or perhaps would PostgreSQL or SQLite be more appropriate?

TIA,

Mark