Oracle inserts chr(0) in large memo when saving

Level Extreme platform

Subscription

Corporate profile

Products & Services

Support

Legal

Français

Oracle inserts chr(0) in large memo when saving

Message

From

09/09/2008 07:52:15

Tom Green
Carver Technologies Inc.
Verdun, Quebec, Canada

All

General information

Forum:

Visual FoxPro

Category:

Client/server

Title:

Oracle inserts chr(0) in large memo when saving

Environment versions

Visual FoxPro:

VFP 9 SP2

OS:

Windows XP SP2

Network:

Windows 2008 Server

Database:

Oracle

Miscellaneous

Thread ID:

01346014

Message ID:

01346014

Views:

I am using Oracle 10g with the Microsoft ODBC driver.

When I save a cursor with a large memo field, containing over 2000 characters, the 2000th character is often replaced with a chr(0). I may have seen this at the 1000th character as well, but I am not sure.

I don't know if this is a VFP problem or an Oracle problem or an ODBC problem. Have any of you seen this, and do you have a solution other than an ugly work-around?

TIA. -- Tom.

Tom Green in Montreal

Map

View

Click here to load this message in the networking platform