Ext + PostgreSQL question

[Topper]

Hello. Im trying to show in my site the result of a query to a table filled with an Ext form. The problem I have is that Ext is storing the carriage returns like some weird char (a square) because the database (and table) encoding is utf-8.

Is there any way to parse it? Or the only solution is changing the database to other encoding? Thx.

[trbs]

This is probably not PostgreSQL specific, the square is normally a character that your browser uses to display something it cannnot find a better representation for.

PostgreSQL and UTF-8 encoded tables are fine, that's what i use all the time. I'm betting that your browser pages or your server side code (Php/Python/Java?) is mangling the characters up. Like when the database is UTF-8 and the form is submitted in Latin-1.

Hope this helps. (PostgreSQL rocks ! ;) )

[Topper]

I solved. You were right, the java server side code was screwing the form submission. I added a UTF8 filter and now the form is stored ok in the DB. And about the squares, a simple string.replaceAll('\n','<br>') while fetching the recordset did the trick.

Regards.
Topper

[trbs]

ah ofcourse squares are often \n 's :)

cool good luck with your project