OraFAQ Forum: Server Administration » Text entry into VARCHAR2 column results in junk data

Home » RDBMS Server » Server Administration » Text entry into VARCHAR2 column results in junk data

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

Text entry into VARCHAR2 column results in junk data [message #372271]

Wed, 24 January 2001 08:49

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

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:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Mon Dec 23 00:19:39 CST 2024