php-windows Digest 25 Apr 2009 08:03:58 -0000 Issue 3611
Topics (messages 29283 through 29284):
Oracle OCI and characterset issue
29283 by: Sascha Meyer
Make $110,324 Per Month!
29284 by: Angela Braun
Administrivia:
To subscribe to the digest, e-mail:
php-windows-digest-subscr...@lists.php.net
To unsubscribe from the digest, e-mail:
php-windows-digest-unsubscr...@lists.php.net
To post to the list, e-mail:
php-wind...@lists.php.net
----------------------------------------------------------------------
--- Begin Message ---
Hi there,
I hope that one or another Oracle specialist is on our list, so here's
something special for you:
I recently upgraded from Zend Core for Oracle 2.0 to 2.5 (I still use the same
php.ini I used with 2.0), and now my database language setup is messed up! All
german umlauts are gone and I haven't found a way to get them back.
This is my setup and database connection handling:
1.) I set up the system-wide environment variable:
"NLS_LANG=GERMAN_GERMANY.WE8ISO8859P9"
2.) Additionally, I set up the environment variable within my php script:
putenv("NLS_LANG=GERMAN_GERMANY.WE8ISO8859P9");
3.) Right before executing:
$this->dbh = oci_pconnect($dbUser, $dbPass, "//$dbHost:$dbPort/$dbName",
"NLS_LANG=GERMAN_GERMANY.WE8ISO8859P9");
Worked before, but now querying Oracle session language setup ("SELECT * FROM
NLS_SESSION_PARAMETERS") returns this:
--------------------------
NLS_LANGUAGE AMERICAN
NLS_TERRITORY AMERICA
NLS_CURRENCY $
NLS_ISO_CURRENCY AMERICA
NLS_NUMERIC_CHARACTERS .,
NLS_CALENDAR GREGORIAN
NLS_DATE_FORMAT DD-MON-RR
NLS_DATE_LANGUAGE AMERICAN
NLS_SORT BINARY
NLS_TIME_FORMAT HH.MI.SSXFF AM
NLS_TIMESTAMP_FORMAT YYYY-MM-DD HH24:MI:SS
NLS_TIME_TZ_FORMAT HH.MI.SSXFF AM TZR
NLS_TIMESTAMP_TZ_FORMAT DD-MON-RR HH.MI.SSXFF AM TZR
NLS_DUAL_CURRENCY $
NLS_COMP BINARY
NLS_LENGTH_SEMANTICS BYTE
NLS_NCHAR_CONV_EXCP FALSE
--------------------------
Any ideas and help greatly appreciated!!
Thanks a lot!
Regards, Sascha
--
Neu: GMX FreeDSL Komplettanschluss mit DSL 6.000 Flatrate + Telefonanschluss
für nur 17,95 Euro/mtl.!*
http://dslspecial.gmx.de/freedsl-surfflat/?ac=OM.AD.PD003K11308T4569a
--- End Message ---
--- Begin Message ---
What a nice day is today! Why? Because the newest money making system is
finally available!
If you are looking for a system, developed by millionaires, and proven to
generate at least $354.97 per day from home, this may very well be the most
important letter you will ever receive!
If You want something that is easy and 100% automated, our money making system
is just what you need! The best part is that it has a TRIAL period so you have
nothing to loose.
Simply reply to tia.mcnitt1...@gmail.com if you want to have more details about
our EXTRAORDINARY ONE-TIME-IN-LIFE offer!
Best wishes!
MMM Club Affiliates
------------------------------------------------------------------
This email has been written and proved to be in compliance with the recently
established can-spam act law in US. We are not provoking or forcing any person
in any way to participate in our programs. To participate is your own decision
and you carry the responsibility of taking further part in this promotion.
Anyway, if you don't want to receive more good offers from us, you can simply
Unsubscribe by sending us a notification email to out_of_the_l...@yahoo.com
with a mail-subject and text "Unsubscribe me", and we will get your email out
of our list within 10 days.
This message is STRICTLY CONFIDENTIAL and is solely for the individual or
organisation to whom it is addressed. It may contain PRIVILEGED and
CONFIDENTIAL information. If you are not the intended recipient, you are hereby
notified that any dissemination, distribution or copying of this communication
and its contents is strictly prohibited. If you are not the intended recipient
you should not read, copy, distribute, disclose or otherwise use the
information in this email. Email may be susceptible to data corruption,
interception and unauthorised amendment, and we do not accept liability for any
such corruption, interception or amendment or the consequences thereof or your
reliance on any information contained therein if you are not the intended
recipient. If you are not interested in the offered promotions, please just
don't answer. If you think you have received this message and its contents in
error, please delete it from your computer, or follow the unsubscribing
procedure shown above.
------------------------------------------------------------------
--- End Message ---
