for who has problems with characters like àòèéùì, just set everything as UTF-8 and database as UTF8_UNICODE_CI, plus if you have a database field with text datatype then when echoing the content of that fields, use nl2br(fieldname[index]); to convert those \\n into html's <br/.

Thanks anyway!

See ya! 🙂

Luigi

Thanks...

Luigi

I mean when you write something, then go in a new line, then write something again...then in the front it should appear as like I wrote but it shows as like it is in the same line...

So I am asking if maybe ISO-8859-1 doesn't support new-line-characters (like that \\n in C++'s printf)?...

Thanks,

Luigi

Example:

I write in the grid text field:

"I eat an apple.

I eat an apple."

On the front it shows as like:

"I eat an apple. I eat an apple."

Sorry I do not understand what you try to explain me

Regards

Tony

as you know, iso-8859-1 should save also carriage return characters?....because I see correctly those letters àòùèéì but when I go in a new line, it shows right next the point like new line character wasn't saved...

Thanks,

Luigi

Sorry to reply so late but I was hardly busy...anyway I figured out about those letters òàùèéì and now I read them OK but seems it doesn't save/read correctly the carriage return character... maybe the iso-8859-1 encoding doesn't support it?....

Thanks
Ciao
Luigi

When you post data to the server maybe you should send custom headers with iso-8859-1 encoding. See in jQuery docs how to do that - hint you can use beforeSend parameter in the ajax call.

Regards

Tony

P.S. Using CDATA is good idea, but do not forget to use the header function in PHP before sending the data to the grid.

well I settled textarea and I'm using simple post with mysql_query and INSERT INTO. Plus I settled default_charset = "iso-8859-1" in php.ini but when I save to database and I look inside the database with phpmyadmin I see the text lost those characters like òàìèù....

Maybe shall I need to use a different charset as default_charset? or could be that echo "<cell><![CDATA[". $row["offerta"]."]]></cell>"; where I should maybe use something different than CDATA? or some other parameters that I don't know?....

Thanks again to everyone!

Ciao!

Luigi

Use edittype:textarea when you edit the field.

Regards

Tony

In the grid I have a field that's connected to a TEXT MySQL field which I want to save also formatted text with characters like òàùèì and carriage returns.... is there maybe a parameter or something in the code that should allow to save them?....

Thanks to everyone!

Ciao,

Luigi