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 >
