Character validation with DB2 Fed Server and Optim

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

In response to

Browse pgsql-general by date

  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