[Erp5-dev] Using another character set and collation

[Łukasz Nowak]

Hello,

By default MySQL's default-character-set is latin1 and collation-server
= default-collation = latin1_swedish_ci.

But I'd like to use:
character set latin2
collation latin2_general_ci

So I've modified my.cnf to have:

[mysqld]
character-set-server = "latin2"
character-set-client = "latin2"
collation-server = "latin2_general_ci"


After this created database for ERP5 installation (eg. erp5localtest),
made sure, that its collation is latin2_general_ci (checked twice).

Installed erp5_base Business Template.

Created organisation, which title has some national characters.

Such script:
for q in context.portal_catalog(
  portal_type = 'Organisation',
  title = 'Ą%' # any national character - for empty or w/o national
charcter all is working
):
  print q.getRelativeUrl()

return printed

Produces attached traceback.

What else shall I do, to use latin2 character set and collation?

Revision: 20709
Products: CMFActivity ERP5 ERP5Catalog ERP5OOo ERP5Subversion
ERP5Type ZMySQLDA ZSQLCatalog CMFCategory ERP5Banking ERP5Form
ERP5Security ERP5SyncML ERP5Wizard TimerService ZMySQLDDA
Zope: (Zope 2.8.9.1-final, python 2.4.4, linux2)

Regards,
Luke

-- 
Łukasz Nowak R&D Ventis http://www.ventis.com.pl/
tel: +48 32 768 16 85 fax: +48 32 392 10 61
``Use the Source, Luke...'' I am only craftsman.
-------------- next part --------------
An embedded and charset-unspecified text was scrubbed...
Name: Illegal mix of collations-traceback.txt
URL: <http://mail.tiolive.com/pipermail/erp5-dev/attachments/20080423/e79ee984/attachment.txt>