How to determine what characters these are being stored in the Oracle Database so I can properly configure my Putty session?

149 Views Asked by At

Using Oracle and within SQL*Plus I execute a SQL command using the DUMP function.

SQL> select DUMP(Field1, 16) from MY_TABLE;

It prints out the following :

Typ=1 Len=10 CharacterSet=AL32UTF8: c3,83,e2,82,ac,c3,83,e2,82,ac

The SQL*Plus session is run within my Putty session and when the "Remote character set :" configuration is changed to various settings (UTF-8, ISO-8859-1:1998 (Latin-1, West Europe), ....) , different characters appear.

Using UTF-8 conversion (assuming it is done correctly) with the above info it almost seems like it should be the same 2 characters.

c3         83
11000011   10000011
11000011
C3


e2        82        ac
11100010  10000010  10101100
10000010101100
20AC

How can I tell exactly what characters (whether it is 1,2 or more characters) it should be then I know that my Putty session is configured correctly?

0

There are 0 best solutions below