Bug #9390

UTF-8 Support

Details

Request #9390	UTF-8 Support
Submitted	2006-11-20 05:48 UTC
From	pearbugs2006 at reddreamer dot com
Status	Bogus
Package	MDB2_Schema
PHP Version	5.1.2
OS	Ubuntu
Roadmaps	(Not assigned)

Comments

[2006-11-20 05:48 UTC] pearbugs2006 at reddreamer dot com

Description:
------------
I'm working on an internationalized application and using LiveUser with a MySQL container. It's a great component, thanks. I'd like to eventually support user names in double-byte languages, which would require a way to specify the encoding and collation of the database tables that the installer creates, and possibly making sure that the string handling that's done is binary-safe.

[2006-12-13 17:00 UTC] pearbugs2006 at reddreamer dot com

It's good to know that the set charset thing would work for the connection at runtime. But if my web host has the MySQL database default to a latin character set, how would I get the demodata.php script to create my tables and columns as UTF-8?

I found a way to hack it by creating my own version of MDB2/Schema.php, which gets everything but the sequence tables to be UTF-8. After doing that, and if you think that everything otherwise will work if the connection object is set to UTF-8, I'm realizing that this is more of a MDB2_Schema problem. Shall I re-report it under that package, or do we want to simply switch the package field on this bug?