Home » RDBMS Server » Server Administration » Text entry into VARCHAR2 column results in junk data
Text entry into VARCHAR2 column results in junk data [message #372271] Wed, 24 January 2001 08:49 Go to next message
Charleton
Messages: 4
Registered: September 2000
Junior Member
Has anyone ever run into this problem? I have an application that is inserting data into a column defined as VARCHAR2(256). It is a text field. When the data is entered, and the record saved, it looks fine. When the record is re-queried to the window, the data is bad, it is full of junk characters, and is unreadable. When the column definition is changed in the Oracle database from VARCHAR2(256) to CHAR(256), the problem is gone, and the data looks normal when it is re-queried to the window. Sound familiar? Any clues?

Report message to a moderator

Re: Text entry into VARCHAR2 column results in junk data [message #372287 is a reply to message #372271] Mon, 29 January 2001 14:35 Go to previous message
Sudhir M. Pongurlekar
Messages: 8
Registered: January 2001
Junior Member
try using varchar2(255)

Report message to a moderator

Previous Topic: SQL HELP PLEEZ!
Next Topic: decode for Date Month Columns
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Thu May 16 20:44:36 CDT 2024
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.