Ticket #7 (closed defect: worksforme)

Opened 3 years ago

Last modified 3 years ago

Character encoding problem

Reported by: juhamh@gmail.com Assigned to: fox
Priority: major Milestone:
Component: backend Version: 1.0.7
Keywords: Cc:

Description

I'm reading many Finnish feeds, but the Tiny Tiny RSS reader interface messes up the character encoding. I set up the database as UTF-8 as said in the README. Then I changed from backend.php pg_query("set client_encoding = 'utf-8'"); to client_encoding latin1, and now I am able to see the texts correctly. Is this just a problem related to my system? Or is the feeds?

I'm running Postgres 8.0.3 and PHP 4.4.0.

Change History

12/11/05 20:03:21 changed by fox

Could you provide some feed links? Basically, everything should "just work" in unicode.

Anyway, some ideas:

  1. If you have to force latin1 for connection you could be having some weird PG client/server/whatever issue. You could try entering finnish data from PG command line client and see if that works (if you have shell access, of course...)
  2. Also, check your magpierss version (they don't link latest on the main page, try 0.72).

01/07/06 17:49:13 changed by fox

  • status changed from new to closed.
  • resolution set to worksforme.