From: | "Alexander Gataric" <gataric(at)usa(dot)net> |
---|---|
To: | <pgsql-general(at)postgresql(dot)org> |
Subject: | Character validation with DB2 Fed Server and Optim |
Date: | 2012-08-04 03:02:36 |
Message-ID: | 007201cd71ed$9a829790$cf87c6b0$@net |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
I'm going to be accessing a Postgres database through DB2 Federated Server
and extracting/inserting with IBM Optim. I want to verify that Optim and DB2
are not corrupting text characters. This SQL should generate a sample set of
characters:
Select genseries, chr( genseries) from generate_series(1,2000) as genseries
After extracting with Optim and inserting into a new table, I can write a
simple query to compare the tables for differences. The Postgres database is
using UTF8 encoding. I'm not sure if the chr function is the best way to
generate a sample set of characters and I'm not if this is the correct
range.
I would appreciate any feedback on this approach and welcome suggestions on
another approach.
Thanks
Alex
From | Date | Subject | |
---|---|---|---|
Next Message | Jasen Betts | 2012-08-04 05:07:29 | Re: Debian upgrade with PostgreSQL |
Previous Message | Craig Ringer | 2012-08-04 01:39:12 | Installer problem report with interesting solution |