Orca and Euorpean charset

[daffydk]

hmm i just cant get orca to work with the special ISO-8859-1 charset
is there anything to do with that ?

[Smoge]

Do a view html source in your browser - see what the:

<meta http-equiv="Content-Type" content="text/html; charset=ISO-8859-1" />

is set to.

Thats where I would start to trouble shoot that.

Smoge

[daffydk]

I didt change that but it gives me crapy chars when inserting in the sql.

dont get it

[Smoge]

You perhaps want, for mySQL

MySQL charset:  UTF-8 Unicode (utf8)

MySQL connection collation: utf8_unicode_ci
(or uft8-unicode_binary)

MySQL database collation: utf8_unicode_ci
(or uft8-unicode_binary)

To support your language, as utf8 will support multiple language character sets in the database.

[daffydk]

Well can i apply that on the existing forum sql or ?

becose the users can post with special chars and register with special chars its just the orca one that doesnt work for me

[Smoge]

I don't really work much with Orca - maybe will HAVE TOO someday I guess... but yes - you can (after a backup) try changing the collation for some of the Orca tables - maybe they should be utf8_unicode_ci

Smoge

[Fjodor]

Orca seems to do htmlspecialchars on the entered text, which is a Bad Thing(tm), since Orca tries to do XML (Good Thing(tm)) in which most html-escaped characters are invalid entities. I have made some improvements that I'll be happy to share, but I think my first order of business is to get them to do it right at boonex in the first place (working on it).

/F

[snivbonk]

Orca seems to do htmlspecialchars on the entered text, which is a Bad Thing(tm), since Orca tries to do XML (Good Thing(tm)) in which most html-escaped characters are invalid entities. I have made some improvements that I'll be happy to share, but I think my first order of business is to get them to do it right at boonex in the first place (working on it).

/F

I would be most grateful if you shared your fix for this, since Boonex doesn't seem to have bothered yet.

(Using standard install of Dolphin 6.02+Orca (which is the problem)).

TIA,

-v