This discussion is archived
1 Reply Latest reply: Mar 23, 2010 10:01 AM by gdarling - oracle RSS

oo4o and Font

761574 Newbie
Currently Being Moderated
i got: oracle 9i 9.2.0.1.0 on win Xp sp3 & and oo4o 9.2.0.7.0
NLS_LANG=AMERICAN_AMERICA.VN8VN3
and my application base on vb6.
if i use ADODB to print my database to text file is okay
but when i use oo4o then i have problem with font type. i dont know why. maybe oo4o 9.2.0.7.0 doesnt support for vietnamese language?
anyone know about it? plz help me.
  • 1. Re: oo4o and Font
    gdarling - oracle Expert
    Currently Being Moderated
    Hi,

    OO4O doesn't have a notion of "font" per se. That's a display thing.

    I have no experience with Vietnamese or that characterset, but I can tell you that a large percentage of NLS issues result from data being incorrectly stored in the database. People insert data via sqlplus for example, retrieve it via sqlplus, they end up with what they started with so they assume all is correct. That is NOT the case. The data needs to be stored validly, and that's the very first thing you should check before moving forward.

    What I'd recommend for starters is
    1) use a table with a single column and a single row for the sake of investigating
    2) insert a single character into the column
    3) dump the storage of the character
    SELECT DUMP(col_name,1016) FROM table_name
    4) check the resulting encoding to see if it's correct for that characterset.
    5) assuming that that is correct, then try selecting the data via oo4o and see what your results are.

    Also, what do you have NLS_LANG set to on the Oracle client machine?
    HKEY_LOCAL_MACHINE\SOFTWARE\ORACLE\KEY_<home_name>\NLS_LANG

    Greg

Legend

  • Correct Answers - 10 points
  • Helpful Answers - 5 points