I did some digging around and I found the soloution on Oracle's page: http://www.oracle.com/technology/pub/articles/php_experts/otn_pdo_oracle5.html
Basically, have to set charset to UTF8. It's already supported within PDO OCI, just need to pass in charset=UTF8 and the DNS will set itself all up. ^_^ --- Philip [EMAIL PROTECTED] http://www.gpcentre.net/ On Tue, Aug 5, 2008 at 2:53 PM, <[EMAIL PROTECTED]> wrote: > I had the same trouble about a year ago using Zend_Db and Oracle adapter. > > If you are using "oci" you can set the connection information with > environment variables. > > /** > * > * Oracle Environment Variables. > * > * Set the default language and characters as UTF8 > * Set the date format. > * > */ > putenv("NLS_LANG=AMERICAN_AMERICA.AL32UTF8"); > putenv("NLS_DATE_FORMAT=YYYY-MM-DD HH24:MI:SS"); > > By default, the connection was created using ISO-8859-1, once I changed > the environment variable... every insert and update worked fine. > > Note: Make sure your enconding is UTF-8 for php files and input. > > I dunno if that works for you or with pdo_oci. > > But I highly recommend to use Zend Core for Oracle if you are dealing with > Oracle databases. > > > > It's an Oracle database. Oops. Missed that piece. > > > > The data is submitted via the web through AMFPHP. The data is in the PHP > > variables correctly. It's just going from $db->insert() to the database > it > > gets altered. > > > > --- > > Philip > > [EMAIL PROTECTED] > > http://www.gpcentre.net/ > > > > > > On Tue, Aug 5, 2008 at 11:14 AM, Xavier Vidal Piera > > <[EMAIL PROTECTED]>wrote: > > > >> Which database are you using? MySQL, PostgreSQL, Oracle...? > >> > >> Have you tried to specify the client encoding in database connection > >> setup? > >> > >> In MySQLi and PDO_MySQL will be > >> $db->query('SET NAMES UTF8'); > >> > >> if you're inserting data with a web form, the page encoding is utf-8? > >> > >> > >> On Tue, Aug 5, 2008 at 18:07, Philip G <[EMAIL PROTECTED]> wrote: > >> > >>> I'm trying to insert a name into our database using the following > >>> call: $db->insert( 'MBR_GEN', $data, 'EML' ); > >>> > >>> $data includes the column names to value. One column is 'FIRST_NM' and > >>> the value is: Josué > >>> However, when I insert it into our database, it inserts as: Josu¿¿ > >>> > >>> I've even did a var_dump() of $data and it shows fine there. It's only > >>> when I insert. I manually altered the data in the table, and it's > >>> fine. So...our DB seems to support it. Any clue as to why Zend_Db is > >>> altering the value? > >>> > >>> --- > >>> Philip > >>> [EMAIL PROTECTED] > >>> http://www.gpcentre.net/ > >>> > >> > >> > >> > >> -- > >> Xavier Vidal Piera > >> Enginyer Tècnic Informàtic de Gestió > >> Tècnic Especialista Informàtic d'equips > >> [EMAIL PROTECTED] > >> [EMAIL PROTECTED] > >> http://web.xaviervidal.net > >> 610.68.41.78 > >> > > > > >
