pg.ddx.io  pgsql-admin@postgresql.org mailing list archive  
help / color / mirror / Atom feed
Database LATIN1  to UFT-8 (unicode) converting problem
2+ messages / 1 participants
[nested] [flat]

* Database LATIN1  to UFT-8 (unicode) converting problem
@ 2006-04-25 12:51 Andy <frum@ar-sd.net>
  2006-04-26 11:49 ` Re: Database LATIN1  to UFT-8 (unicode) converting problem SOLVED Andy <frum@ar-sd.net>
  0 siblings, 1 reply; 2+ messages in thread

From: Andy @ 2006-04-25 12:51 UTC (permalink / raw)
  To: pgsql-admin

Hi to all, 

We just tried to switch out database from LATIN 1 (ISO 8859-1) to UTF-8. After a few tests we found out some problems:
 - the upper and lower functions does not work for all characters. Especially lower returns nothing if a umlaut is in the converted string. The umlauts are not converted at all.
- the returned rows are not correctly sorted. ö is before a and so on. 

The server is a Suse 10 system. DB is Postgresql 8.0.3. 

This sorting problem we had it before and it was the problem was at local system settings. Now everything is switched to UTF-8 (or it seems so). 

Please advise. 

Thank you,
Andy.

^ permalink  raw  reply  [nested|flat] 2+ messages in thread

* Re: Database LATIN1  to UFT-8 (unicode) converting problem SOLVED
  2006-04-25 12:51 Database LATIN1  to UFT-8 (unicode) converting problem Andy <frum@ar-sd.net>
@ 2006-04-26 11:49 ` Andy <frum@ar-sd.net>
  0 siblings, 0 replies; 2+ messages in thread

From: Andy @ 2006-04-26 11:49 UTC (permalink / raw)
  To: Andy <frum@ar-sd.net>; pgsql-admin

I found a solution: I re-run initdb with Unicode encoding and now seems to work fine. 

I cannot figure out why did this happen, or does the initdb encoding affects all the databases or the db encoding is not enough to be specified?

Andy.

  ----- Original Message ----- 
  From: Andy 
  To: pgsql-admin@postgresql.org 
  Sent: Tuesday, April 25, 2006 3:51 PM
  Subject: [ADMIN] Database LATIN1 to UFT-8 (unicode) converting problem


  Hi to all, 

  We just tried to switch out database from LATIN 1 (ISO 8859-1) to UTF-8. After a few tests we found out some problems:
   - the upper and lower functions does not work for all characters. Especially lower returns nothing if a umlaut is in the converted string. The umlauts are not converted at all.
  - the returned rows are not correctly sorted. ö is before a and so on. 

  The server is a Suse 10 system. DB is Postgresql 8.0.3. 

  This sorting problem we had it before and it was the problem was at local system settings. Now everything is switched to UTF-8 (or it seems so). 

  Please advise. 

  Thank you,
  Andy.

^ permalink  raw  reply  [nested|flat] 2+ messages in thread


end of thread, other threads:[~2006-04-26 11:49 UTC | newest]

Thread overview: 2+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2006-04-25 12:51 Database LATIN1  to UFT-8 (unicode) converting problem Andy <frum@ar-sd.net>
2006-04-26 11:49 ` Re: Database LATIN1  to UFT-8 (unicode) converting problem SOLVED Andy <frum@ar-sd.net>

This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox