I have an Oracle databse with NLS_CHARACTERSET US7ASCII I have a table "land", like
create table land (
c_land number (4) not null,
zoekarg varchar2 (5),
land varchar2 (40),
diac number (1),
d_in number (8),
d_end number (8),
opm varchar2 (150),
mut number (1),
icao varchar2 (3),
land_u varchar2 (80)
);
In there the field "land" has the content *without* special characters,
like
Zuidrhodesie
the special characters are stored elsewhere, indicated by the field diac
The field land_u contains the extended land *with* diacriticals, like
Zuidrhodesië
^
in UTF-8 encoding. Note that this is possible because of US7ASCII
what is stored in the database is
Zuidrhodesi\303\253
using perl to extract that makes displaying those values easy, but I
have no idea how I can get programs like SQL Developer to show that
content the way it is intended
Is there an oracle function I could use to convert byte-encode UTF-8
to something SQL developer "understands"
select utf8_bytes_to_utf16_for_sql_developer (land_u) from land;
any hint is welcome. Currently SQL Developer will show
Zuidrhodesi��
where the trailing �'s are both \x0fffd (\N{REPLACEMENT CHARACTER}),
which is not really helpful
I have been playing with several variants of
select convert (land_u, 'AL16UTF16', 'UTF8') from land where c_land = 7072;
but I didn't get SQL Developer to show the ë
--
H.Merijn Brand http://tux.nl Perl Monger http://amsterdam.pm.org/
using perl5.00307 .. 5.27 porting perl5 on HP-UX, AIX, and openSUSE
http://mirrors.develooper.com/hpux/ http://www.test-smoke.org/
http://qa.perl.org http://www.goldmark.org/jeff/stupid-disclaimers/
pgpmpQPsRNFz5.pgp
Description: OpenPGP digital signature
