Drupal integration (UTF8 vs ISO)

General talk about translations & I18n (Internationalization)

Drupal integration (UTF8 vs ISO)

Postby konrad1811 » 8:55pm, Sun 22 May, 2011

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 polish.inc to set UTF8 in place of ISO-8859-2 however did'nt help.

Maybe some re-encoding possible?
konrad1811
phpLister
 
Posts: 8
Joined: 8:05pm, Tue 03 May, 2011

Re: Drupal integration (UTF8 vs ISO)

Postby H2B2 » 5:40pm, Mon 23 May, 2011

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
H2B2
Moderator
 
Posts: 7188
Joined: 1:51am, Wed 15 Mar, 2006

Re: Drupal integration (UTF8 vs ISO)

Postby konrad1811 » 10:56am, Wed 25 May, 2011

thanks!!!!!!!!
seems working :]
konrad1811
phpLister
 
Posts: 8
Joined: 8:05pm, Tue 03 May, 2011

Re: Drupal integration (UTF8 vs ISO)

Postby konrad1811 » 11:22am, Wed 25 May, 2011

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...
konrad1811
phpLister
 
Posts: 8
Joined: 8:05pm, Tue 03 May, 2011

Re: Drupal integration (UTF8 vs ISO)

Postby konrad1811 » 11:31am, Wed 25 May, 2011

checked SQL query:

SHOW VARIABLES LIKE 'char%'

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?)
konrad1811
phpLister
 
Posts: 8
Joined: 8:05pm, Tue 03 May, 2011

Re: Drupal integration (UTF8 vs ISO)

Postby konrad1811 » 2:47pm, Fri 27 May, 2011

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

BUT
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
konrad1811
phpLister
 
Posts: 8
Joined: 8:05pm, Tue 03 May, 2011

Re: Drupal integration (UTF8 vs ISO)

Postby konrad1811 » 3:34pm, Fri 27 May, 2011

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! :)
konrad1811
phpLister
 
Posts: 8
Joined: 8:05pm, Tue 03 May, 2011


Return to Translators & Internationalization

Who is online

Users browsing this forum: No registered users and 2 guests