pg.ddx.io pgsql-admin@postgresql.org mailing list archivehelp / 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> 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-26 11:49 Andy <frum@ar-sd.net> parent: 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