Displaying diacritics in SQL reports

Question

When running reports in SQL, diacritics are not displaying properly.

The NLS_LANG in aleph_start is set to American_America.UTF8

Is it possible to get the character sets that p-manage-22 (the "Character conversion" service) converts from UTF to whatever? This would allow CONVERT to be used in SQL statements.

Answer

The conversion tables that p_manage_22 uses are all in the ./alephe/unicode directory, and the file tab_character_conversion_line specifies which table will be used. It is unlikely that SQL could use these tables, as it has its own tables.

CONVERT can be used with SQL query SELECT statements (e.g.):
SELECT CONVERT(Z13_TITLE, 'WE8ISO8859P1', 'UTF8'), z13_CALL_NO, etc.

Settings for different languages can be found at:
http://docs.oracle.com/cd/B28359_01/server.111/b28298/applocaledata.htm#i635016

• Article last edited: 10/8/2013