Re: Bug #1485: Cannot store or retrieve german umlauts
| From: | Thies C. Arntzen | Date: | Fri, 04 Jun 1999 10:56:21 +0000 |
| Subject: | Re: Bug #1485: Cannot store or retrieve german umlauts | ||
| References: | 1 | Groups: | php.dev |
| Request: | Send a blank email to php-dev+get-6532@lists.php.net to get a copy of this message | ||
hi,
something in you setup must be wrong.
just created a database with:
-------------
connect internal
startup nomount PFILE=initTC.ora
create database TC
character set WE8DEC
datafile '/dot/oracle/data/TC/sys.ora' size 16M
logfile
group 1 ('/dot/oracle/data/TC/log1.ora') size 128K,
group 2 ('/dot/oracle/data/TC/log2.ora') size 128K;
@?/rdbms/admin/catalog
@?/rdbms/admin/catproc
create tablespace RBS
datafile '/dot/oracle/data/TC/rbs.ora' size 128k;
CREATE ROLLBACK SEGMENT r01 TABLESPACE RBS;
CREATE ROLLBACK SEGMENT r02 TABLESPACE RBS;
CREATE ROLLBACK SEGMENT r03 TABLESPACE RBS;
CREATE ROLLBACK SEGMENT r04 TABLESPACE RBS;
ALTER ROLLBACK SEGMENT r01 ONLINE;
ALTER ROLLBACK SEGMENT r02 ONLINE;
ALTER ROLLBACK SEGMENT r03 ONLINE;
ALTER ROLLBACK SEGMENT r04 ONLINE;
---------------
initTC.ora:
control_files = (/dot/oracle/data/TC/control.ora)
rollback_segments = (r01,r02,r03,r04)
db_name = TC
----------------
oracle@godzilla.digicol.old<36>sqlplus system/manager
SQL*Plus: Release 8.0.5.0.0 - Production on Fri Jun 4 12:51:1 1999
(c) Copyright 1998 Oracle Corporation. All rights reserved.
Connected to:
Oracle8 Enterprise Edition Release 8.0.5.1.0 - Production
With the Partitioning and Objects options
PL/SQL Release 8.0.5.1.0 - Production
SQL> select VALUE from v$nls_parameters;
VALUE
----------------------------------------------------------------
AMERICAN
AMERICA
$
AMERICA
.,
GREGORIAN
YYYY-MM-DD HH24:MI:SS
AMERICAN
WE8DEC
BINARY
WE8DEC
so we got the "WE8DEC" charset, ok?
then:
SQL> create table tubu (tc varchar2(32));
Table created.
SQL> exit
oracle@godzilla.digicol.old<37>echo $NLS_LANG
american_america.WE8DEC
oracle@godzilla.digicol.old<38>cat tubu.php3
<?
$c = ocilogon("system","manager");
$st = ociparse($c,"insert into tubu values ('hälüß')");
ociexecute($st);
$st = ociparse($c,"select * from tubu");
ociexecute($st);
while (ocifetch($st))
{ echo ociresult($st,1)."\n";
}
?>
oracle@godzilla.digicol.old<39>/dot/dc4/bin/php tubu.php3
Content-type: text/html
hälüß
oracle@godzilla.digicol.old<40>
please double-check your environment!
tc
PS: i always use WE8ISO8859P1 as my internal and external char-set!
On 2 Jun 1999 henneberg@netco.de wrote:
> From: henneberg@netco.de
> Operating system: Linux 2.0.36
> PHP version: 3.0.7
> PHP Bug Type: Oracle related
> Bug description: Cannot store or retrieve german umlauts
>
> ORACLE 8.0.5.0.0 Enterprise for Linux
>
> character set "WE8DEC"
> national character set "WE8DEC"
>
> OCI8 Oracle version: 8.0
> Compile-time ORACLE_HOME: /u01/app/oracle/product/8.0.5
> Libraries used: -lclntsh -lpsa -lcore4 -lnlsrtl3 -lclntsh -lm
>
> <?php
> $stmt = OCIParse($conn,"update typ set typname='ÖÄÜöäüß' where
> typid=3");
> ...
> ...
> $stmt = OCIParse($conn,"select * from typ");
> ...
> ?>
> Result: VD\vd|_
>
> Java/Java Servlet JDBC and Microsoft ODBC work good.
>
> ./configure --with-apxs=/opt/apache/bin/apxs \
> --with-config-file-path=/opt/apache/conf \
> --enable-track-vars \
> --with-oracle
>
>
>
> --
> PHP Development Mailing List (http://www.php.net/)
> To unsubscribe, e-mail: php-dev-unsubscribe@lists.php.net
> For additional commands, e-mail: php-dev-help@lists.php.net
> To contact the list administrators, e-mail: php-list-admin@lists.php.net
>
>
Thies C. Arntzen "One Big-Mac, Small Fries and a Coke!"
Digital Collections Phone +49 40 235350 Fax +49 40 23535180
Hammerbrookstr. 93 20097 Hamburg / Germany