Xinha Discussion Forum

steff

New member

Registered: 2005-07-05

Posts: 1

I have a problem with German spezial Characters

Hi.

I am from germany and i have a problem with the german special characters.

I use Xinha as an Replacement for a textarea in an form.
The enterd text i save in a mysql database.

With PHPMyAdmin i see that Xinha changes the entered text like this:

<p>Ärmel Öfen ölig übersichtlich<br /><br />Übungen Ärgerlich </p>

it shold look like this:

Ärmel Öfen ölig übersichtlich

Übungen Ärgerlich

Have someone an idear?

Last edited by steff (2005-07-05 10:44:39)

niko

Xinha Authority

From: Salzburg/Austria

Registered: 2005-02-14

Posts: 338

Re: I have a problem with German spezial Characters

This is correct, only phpMyAdmin uses a wrong charset (i assume iso-8859-1) to display the text.
Xinha uses the charset from the page where the textarea is placed, which would be in your case UTF-8.

several solutions:
- use iso-8859-1 in your page where you use xinha
- switch the charset in phpMyAdmin (possible in recent versions of pma i think) AND use utf-8 in the page where you output the html-code
- ignore the problem in phpMyAdmin and use utf-8 only in the page where you output the code
- use server-side php-function uft8_decode (NOT recommended)

---

Niko

mharrisonline

Xinha Administrator

From: Denver, Colorado

Registered: 2005-04-11

Posts: 110

Website

Re: I have a problem with German spezial Characters

I bet Ticket 127 would fix this.

http://xinha.python-hosting.com/ticket/127

camille

Xinha Community Member

Registered: 2005-05-06

Posts: 12

Re: I have a problem with German spezial Characters

I had the same problem and have been playing with the iso-8859-1 and the UTF-8.

Now I've put iso-8859-1 in the page where the txteditor is integrated and in the page too where I read from the database, where the text is displayed.
In both the character has been displayed right.

But I read that in the page where the Xinha-texteditor is included, that it's the UTF-8 that the page needs.  In my case, it saves strange characters into the database.

I don't understand why I should been using the UTF-8, that will give me but problems.

fede@

New member

Registered: 2005-09-22

Posts: 2

Re: I have a problem with German spezial Characters

I have the same problem

I used  UTF-8 , but  the problem isn't change

do you know why?

niko

Xinha Authority

From: Salzburg/Austria

Registered: 2005-02-14

Posts: 338

Re: I have a problem with German spezial Characters

you dont HAVE to use utf8, although we recommend it.

and if you use utf8 - you must use it everywhere - in the admin-site where your xinha is AND in the frontend where you display the html-code!

it might be correct when you have those strange characters in the database! because these characters are in utf8 - and your database-application probably doesn't know that! so you can in most cases ignore this.

---

Niko

fede@

New member

Registered: 2005-09-22

Posts: 2

Re: I have a problem with German spezial Characters

but how can do for the special character ?

thanks

niko

Xinha Authority

From: Salzburg/Austria

Registered: 2005-02-14

Posts: 338

Re: I have a problem with German spezial Characters

there is nothing different from an ä to any other special character

they are ALL avaliable through utf8 (which is the nice thing about utf8)

---

Niko