From: | Geoffrey Myers <geof(at)serioustechnology(dot)com> |
---|---|
To: | Vick Khera <vivek(at)khera(dot)org> |
Cc: | pgsql-general <pgsql-general(at)postgresql(dot)org> |
Subject: | Re: converting databases form SQL_ASCII to UTF8 |
Date: | 2011-04-22 15:16:24 |
Message-ID: | 4DB19BC8.2070008@serioustechnology.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
Vick Khera wrote:
> On Fri, Apr 22, 2011 at 11:00 AM, Geoffrey Myers
> <lists(at)serioustechnology(dot)com <mailto:lists(at)serioustechnology(dot)com>> wrote:
>
> Here's our problem. We planned on moving databases a few at a time.
> Problem is, there is a process that pushes data from one database to
> another. If this process attempts to push data from a SQL_ASCII
> database to a new UTF8 database and it has one of these characters
> mentioned above, the process fails.
>
>
> The database's enforcement of the encoding should be the last layer that
> does so. Your applications should be enforcing strict utf-8 encoding
> from start to finish. Once this is done, and the old data already in
> the DB is properly encoded as utf-8, then there should be no problems
> switching on the utf-8 encoding in postgres to get that final layer of
> verification.
Totally agree. Still, the question remains, why not leave it as SQL_ASCII?
--
Geoffrey Myers
Myers Consulting Inc.
770.592.1651
From | Date | Subject | |
---|---|---|---|
Next Message | Adrian Klaver | 2011-04-22 15:27:51 | Re: converting databases form SQL_ASCII to UTF8 |
Previous Message | Vick Khera | 2011-04-22 15:05:47 | Re: converting databases form SQL_ASCII to UTF8 |