trouble with fetch from oralce db

lem

When I use ora_xxx functions to connect to oracle 7 and fetch data from it,
the English character is pretty good,but the Chinese character all turn to
be '?'.
what about this problem ?
Is there any advices for this trouble ?

Thanks very much!

Jul 16 '05 #1

Subscribe Reply

2010

Andy Hassall

On Tue, 15 Jul 2003 16:16:13 +0800, "lem" <lx*****@sina.com> wrote:

When I use ora_xxx functions to connect to oracle 7 and fetch data from it,
the English character is pretty good,but the Chinese character all turn to
be '?'.
what about this problem ?

That'll be due to your NLS_LANG settings.

Although even if you sort that, you're running an version of Oracle that was
desupported last millenium, using the obsolete Oracle 7-based PHP extension,
getting multibyte data into a language that doesn't deal with multibyte very
well (PHP). So there's probably more trouble ahead...

--
Andy Hassall (an**@andyh.co.uk) icq(5747695) (http://www.andyh.co.uk)
Space: disk usage analysis tool (http://www.andyhsoftware.co.uk/space)

Jul 16 '05 #2

Similar topics

2595

Trouble Installing Smarty could really do with some help

by: M | last post by:

Hi Folks, I am trying to install Smarty using PHP 5 on a Windows XP PC using IIS v6 The following PHP File: <!doctype html public "-//W3C//DTD HTML 4.0 //EN"> <html> <head>

PHP

4399

python 2.3.4, cx_Oracle 4.1 and utf-8 - trouble

by: Maxim Kuleshov | last post by:

Hello! Trying to fetch long varchar2 column and get the following error: cx_Oracle.DatabaseError: column at array pos 0 fetched with error: 1406 i.e. string buffer is not much enough to...

Python

7927

trouble shooting oracle instance

by: sjgrad03 | last post by:

Dear members: I have trouble to logon sqlplus. one dbforum member said that my oralce instance doesn't start. I used following command in the command line prompt:

Oracle Database

8625

FETCH arbitrary columns from a ref_cursor

by: Agoston Bejo | last post by:

The problem is as follows: I have a stored proc. that returns a types.ref_cursor (where types.ref_cursor is defined as 'ref cursor'): PROCEDURE P(c OUT TYPES.ref_cursor); The returned cursor has...

Oracle Database

1458

Dynamic SQL trouble

by: Richard | last post by:

Hi all, I had a stored procedure that i wanted to be able to pass parameters to so i used dynamic SQL. I am getting very strange errors though when i try to execute it. My code works just fine,...

Microsoft SQL Server

1174

Trouble with locking tables - reg.

by: Shanmugasundaram Doraisamy | last post by:

Dear Group, We are using Postgresql 7.3.4 on Redhat 8.0 with Java 1.4.2. We are developing our applications in Java. We call stored procedures from the java program. Order numbers are generated...

PostgreSQL Database

3509

MySQLdb - Query/fetch don't return result when it *theorically* should

by: Bernard Lebel | last post by:

Hello, I'm stumbled at a serious problem, and quite frankly getting desparate. This is a rather long-winded one so I'll try to get straight to the point. I have this Python program, that...

Python

1530

Oralce-SQL Utility for pc for learning

by: 2005 | last post by:

Hi Are there any utility software that would install Oralce-SQL on a pc, windows? Thanks

Microsoft Access / VBA

2425

Charset trouble

by: matheussousuke | last post by:

Hi guys, good morning. I've just get this script for converting mysql tables from wordpress, and I want to use it in my server, but no with wordpress, with oscommerce, a friend of mine told me a...

PHP

7153

Changing the language in Windows 10

by: Hystou | last post by:

Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can...

Windows Server

7373

Problem With Comparison Operator <=> in G++

by: Oralloy | last post by:

Hello folks, I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>". The problem is that using the GNU compilers,...

C / C++

7094

The easy way to turn off automatic updates for Windows 10/11

by: Hystou | last post by:

Overview: Windows 11 and 10 have less user interface control over operating system update behaviour than previous versions of Windows. In Windows 11 and 10, there is no way to turn off the Windows...

Windows Server

7519

Discussion: How does Zigbee compare with other wireless protocols in smart home applications?

by: tracyyun | last post by:

Dear forum friends, With the development of smart home technology, a variety of wireless communication protocols have appeared on the market, such as Zigbee, Z-Wave, Wi-Fi, Bluetooth, etc. Each...

General

5677

AI Job Threat for Devs

by: agi2029 | last post by:

Let's talk about the concept of autonomous AI software engineers and no-code agents. These AIs are designed to manage the entire lifecycle of a software development project—planning, coding, testing,...

Career Advice

3218

Windows Forms - .Net 8.0

by: adsilva | last post by:

A Windows Forms form does not have the event Unload, like VB6. What one acts like?

Visual Basic .NET

1585

transfer the data from one system to another through ip address

by: 6302768590 | last post by:

Hai team i want code for transfer the data from one system to another through IP address by using C# our system has to for every 5mins then we have to update the data what the data is updated ...

C# / C Sharp

796

How to add payments to a PHP MySQL app.

by: muto222 | last post by:

How can i add a mobile payment intergratation into php mysql website.

PHP

452

Comprehensive Guide to Website Development in Toronto: Expert Insights from BSMN Consultancy

by: bsmnconsultancy | last post by:

In today's digital era, a well-designed website is crucial for businesses looking to succeed. Whether you're a small business owner or a large corporation in Toronto, having a strong online presence...

General