Forums / Install & configuration / MySQL and Unicode support?

"Please Note:

At the specific request of Ibexa we are changing this projects name to "Exponential" or "Exponential (CMS)" effective as of August, 11th 2025.
This project is not associated with the original eZ Publish software or its original developer, eZ Systems or Ibexa".

MySQL and Unicode support?

Previous topic

Install & configuration

Next topic

Author	Message
Frzzy Madayaz	Wednesday 11 June 2003 9:57:41 am Hey I'm installing 3.1 beta 2 and notice that MySQL won't support Unicode? So what Unicode? My site use UTF-8 encoding text and it's monolingual. Currently I'm using phpBB2 with MySQL and it handle UTF-8 really good.
Bård Farstad	Wednesday 11 June 2003 10:00:49 am MySQL does not support unicode before version 4.1, to get unicode support with Exponential you need to run PostgreSQL or run an alpha version of MySQL. You would need to configure MySQL 4.1 manually as we've not added support for this in the setup wizard. BTW: which version of MySQL are you using with phpBB2? --bård Documentation: http://ez.no/doc
Jan Borsodi	Wednesday 11 June 2003 1:48:55 pm It might be that utf-8 will work on MySQL even without native Unicode support, it really depends on what kind of text handling functions are used Exponential. For instance matching one whole utf8 string against another does not require utf-8 specific functionality, it's actually one of the features of utf8. The places where I see trouble are with searching. It could be an intereseting experiment and see if Exponential would run in utf8 mode on MySQL. -- Amos Documentation: http://ez.no/ez_publish/documentation FAQ: http://ez.no/ez_publish/documentation/faq

Author

Message

Frzzy Madayaz

Wednesday 11 June 2003 9:57:41 am

Hey I'm installing 3.1 beta 2 and notice that MySQL won't support Unicode? So what Unicode? My site use UTF-8 encoding text and it's monolingual. Currently I'm using phpBB2 with MySQL and it handle UTF-8 really good.

Bård Farstad

Wednesday 11 June 2003 10:00:49 am

MySQL does not support unicode before version 4.1, to get unicode support with Exponential you need to run PostgreSQL or run an alpha version of MySQL. You would need to configure MySQL 4.1 manually as we've not added support for this in the setup wizard.

BTW: which version of MySQL are you using with phpBB2?

--bård

Documentation: http://ez.no/doc

Jan Borsodi

Wednesday 11 June 2003 1:48:55 pm

It might be that utf-8 will work on MySQL even without native Unicode support, it really depends on what kind of text handling functions are used Exponential. For instance matching one whole utf8 string against another does not require utf-8 specific functionality, it's actually one of the features of utf8.
The places where I see trouble are with searching.

It could be an intereseting experiment and see if Exponential would run in utf8 mode on MySQL.

--
Amos

Documentation: http://ez.no/ez_publish/documentation
FAQ: http://ez.no/ez_publish/documentation/faq