Norwegian special characters in LightBox and FCKeditor

Regular Joined: Oct 14, 2006 Posts: 60 Location: Norway

Hi all.

Neither LightBox nor FCKeditor shows the Norwegian special characters Sad

1). LightBox shows the characters "æ, ø and å" as black diamonds with a question mark. This occures in news articles when klicked on the read more icon - not in the text itself but in the "postedby/datetime" thing.
2). FCKeditor don't find image files which includes the characters "æ, ø and å" (shows a broken image link only).

Hope you gurus on here can help me out on this one...

Thanks! Smile

Posted: Sat Jul 31, 2010 1:24 pm

If you look at your database in phpmyadmin, is the Collation of your tables utf-8 or is it something like latin1_swedish_ci?

Posted: Sat Jul 31, 2010 1:44 pm

Thank you for your fast reply!

MySQL localhost collation is utf8_general_ci
whilst all MySQL RN tables are latin1_general_ci

Posted: Sat Jul 31, 2010 2:01 pm

I am not 100% sure, but I think the latin1_swedish_ci is preferred for special character languages. Maybe someone else will chime in on this to see if I am correct or not. If you do any changes on your database, make sure you backup what you have before any changes are made.

Edit:
This may have nothing to do with your issue.

Posted: Sat Jul 31, 2010 2:12 pm

Thanks for your last input.

I also have another site running on the very same server.
All RN tables there are latin1_swedish_ci (and I don't have this failure there!. At least not with FCKeditor, don't have LightBox installed there so I wouldn't know...)

I'll give it try and change the collation! Wink

Posted: Sat Jul 31, 2010 2:13 pm

Also, what version of RavenNuke are you using?

Posted: Sat Jul 31, 2010 2:44 pm

I'm running the latest version.

Changing the collation didn't help any...

For others who want to know;
I didn't use phpMyAdmin but run this little script to change the collation for all tables:

Code:

<?php


$db = mysql_connect('localhost','myuser_mydbuser','mypassword');


if(!$db) echo "Cannot connect to the database - incorrect details";


mysql_select_db('myuser_mydbname'); $result=mysql_query('show tables');


while($tables = mysql_fetch_array($result)) {


foreach ($tables as $key => $value) {


mysql_query("ALTER TABLE $value COLLATE utf8_general_ci");


}}


echo "The collation of your database has been successfully changed!";


?>

Make sure to substitute in the above script:
- myuser_mydbname with your database name
- myuser_mydbuser with your mysql username
- mypassword with your password for the mysql user
- utf8-general_ci with your new collation if different

Script source: [ Only registered users can see links on this board! Get registered or login! ]

Posted: Sat Jul 31, 2010 3:02 pm

That script appears to change the collation to utf8_general_ci instead of latin1_swedish_ci. Also, there is an update to the lightbox for the fckeditor which uses the built in colorbox for RavenNuke 2.40 and up. [ Only registered users can see links on this board! Get registered or login! ]

Posted: Sat Jul 31, 2010 3:08 pm

nuken wrote:

That script appears to change the collation to utf8_general_ci instead of latin1_swedish_ci.

True!
Ofcourse I changed the ut8f_general_ci in the script to latin1_swedish_ci Wink

I'll download the update.
Thanks alot! Smile

[edit]Just fixed some misspellings Wink

[/edit]

Posted: Sat Jul 31, 2010 3:15 pm

I figured you did, just wanted to make sure. Very Happy

Posted: Sat Jul 31, 2010 3:54 pm

In RN 3.0 we will be moving to utf_general_ci.