Page 1 of 1

Drupal integration (UTF8 vs ISO)

PostPosted: 8:55pm, Sun 22 May, 2011
by konrad1811
I run drupal website and decided to use phplists.

Installation is done and content is taken via RSS.

However Drupal is UTF8 encoded and PHPlists in ISO 8859-2 (polish)

I set UTF-8 however all polish signes are broke...

Can this really work in UTF-8? Shall I set some things up in other then config.php files?
I also checke to set UTF8 in place of ISO-8859-2 however did'nt help.

Maybe some re-encoding possible?

Re: Drupal integration (UTF8 vs ISO)

PostPosted: 5:40pm, Mon 23 May, 2011
by H2B2
Character set configuration is still a bit of a struggle at the moment. This short tutorial might help: How to configure UTF-8 in phpList

Re: Drupal integration (UTF8 vs ISO)

PostPosted: 10:56am, Wed 25 May, 2011
by konrad1811
seems working :]

Re: Drupal integration (UTF8 vs ISO)

PostPosted: 11:22am, Wed 25 May, 2011
by konrad1811
except that getting rss makes error:

Database error 1267 while doing query Illegal mix of collations (latin1_swedish_ci,IMPLICIT) and (utf8_general_ci,COERCIBLE) for operation '='

Database is set to utf8_general_ci however some of tables have fields and comparison charset is latin although I just set utf for all the database...

I dont get it...

Did all what was said in viewtopic.php?p=81753#p81753

shall I manually edit each field in each table and change the charset of fields???
lots of work and not sure if this is the key to solve this...

Re: Drupal integration (UTF8 vs ISO)

PostPosted: 11:31am, Wed 25 May, 2011
by konrad1811
checked SQL query:


and the result is:
character_set_client utf8
character_set_connection utf8
character_set_database utf8
character_set_filesystem binary
character_set_results utf8
character_set_server latin1
character_set_system utf8

database charset comparison is set utf8
but field tables are latin1-swedish sth...

shall I change them all or somehow change character_ser_server (dont really know how to change it and shall I do it?)

Re: Drupal integration (UTF8 vs ISO)

PostPosted: 2:47pm, Fri 27 May, 2011
by konrad1811
well finaly I did export database and just change all "latin1" to "utf8" and than go back import database...
(only 1 latin1 must have been unchanged as there was database error while loading...)

now my RSS are read in UTF 8 - correctly

all other text on phplists admin pages are broken


however this is partial improvement - user can receive correct message
but when he decides to chenge subscription he land on a page with broken labels...

I checke my language file is UTF8 and in the text editor in UTF8 is correctly displayed
charset on subscription page is UTF 8 and database exept blacklist is utf8...

have no idea what can be still wrong

Re: Drupal integration (UTF8 vs ISO)

PostPosted: 3:34pm, Fri 27 May, 2011
by konrad1811
worked this out:

registration page has its own language settings
just have found it and chosen my own UT8 lagnauage

now registration page is ok

however choosing language for administrator isnot possible (only default language is available and my own defined as utf8 isseen to choose only on registration page)

however the main problem - to present nice labels for website user is solved! :)