Hi All, I'd like to use the same column to store content from multiple languages (English, German, French, Japanese).
Here is my understanding of the options available. In MySQL 4.0: - UTF-8 is not currently available as a charset - we can connect to the database using "useUnicode=true&characterEncoding=UTF-8" in the connection string. - this enables us to store, search and retrieve Unicode content from the column, as long as we always use JDBC with the above connection string, to interact with the db. - sorting will not work on the column In MySQL 4.1: - UTF-8 is available as a charset - We still neet to connect to the database using the above connection string (doesn't seem to work otherwise) - sorting will work, but only using the general utf8 collation (may not work for Japanese?). More collations will be available soon. - [can we cast/convert to a different charset (sjis) and use its collation for sorting? (performance is not really an issue)] Please let me know if any of these assumptions are incorrect. Thanks, Puny Sen -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
