Converting from Unicode

From: Eric Yu <ericyu_at_NOSPAM.centerprise.com>
Date: Wed, 14 Jul 1999 18:52:37 -0400
Message-ID: <Yx8j3.174$On3.7163@client>

I have some strings stored by a third party app in Oracle 8.0.5 as Unicode (I think, where straight select output produces "00310032...").

How can I convert this to straight ascii from a Java prog? I've tried something like:

ResultSet rset = stmt.executeQuery ("select CONVERT(COLNAME, 'US7ASCII',
'AL24UTFFSS') from SCHEMA.TABLENAME");

and

ResultSet rset = stmt.executeQuery ("select CONVERT(COLNAME, 'US7ASCII',
'UTF8') from SCHEMA.TABLENAME");

but neither worked.

Thanks in advance for any tips.

Received on Wed Jul 14 1999 - 17:52:37 CDT