1 Reply Latest reply: Sep 8, 2007 2:43 AM by 596927 RSS

    Wrong character encoding in MS Excel

    user584511
      Hi!
      I get and update data in the database (8i) using oo4o in MS Excel VBA. Data is in Latvian (NLS_LANG is AMERICAN_AMERICA.WE8ISO8859P1)
      The code is:
      Set OSes = CreateObject("OracleInProcServer.XOraSession")
      Set ODb = OSes.OpenDatabase("test", "scott/tiger", 0&)
      Set ODy = ODb.createdynaset("select ename from emp ", 0)
      The problem is, when I get data (ename), or put data into OraPrameter object, all Latvian letters are converted to some simbols. The example of the result is: 'KredØta', where at the place of Ø, should be letter ī.
      I've used this code for some years with Office 2000 and Oracle Client 8i, and everything was ok, but now I have Office 2003 and Client 10g, and it does not work :(