Snitz Forums 2000
Snitz Forums 2000
Home | Profile | Register | Active Topics | Members | Search | FAQ
Username:
Password:
Save Password
Forgot your Password?

 All Forums
 Snitz Forums 2000 DEV-Group
 DEV Discussions (Oracle)
 Oracle 8.1.5.00 ODBC/ TRIM problem
 Forum Locked  Topic Locked
 Printer Friendly
Author Previous Topic Topic Next Topic  

gor
Retired Admin

Netherlands
5511 Posts

Posted - 07 March 2001 :  17:34:36  Show Profile  Visit gor's Homepage
Ok, first this: I do have to use ODBC for this, so no option doing this using OO4O (Oracle Objects for OLE)

When I retrieve a string value from the database, the length of that string is the total field length.
I.e. if the field length is 20 and the stringvalue is "test", what gets returned isn't
"test"
but
"test                "

A way to fix this is to use Trim(), but that would mean that I would have to Trim() each and every value that I retrieve from the database.

Is this default behavior ? Any quick ways around it ?


Pierre<

gor
Retired Admin

Netherlands
5511 Posts

Posted - 09 March 2001 :  13:32:23  Show Profile  Visit gor's Homepage
I was using CHAR() as datatype for those fields, after I switched to VARCHAR() the problem was fixed.

Pierre<
Go to Top of Page
  Previous Topic Topic Next Topic  
 Forum Locked  Topic Locked
 Printer Friendly
Jump To:
Snitz Forums 2000 © 2000-2021 Snitz™ Communications Go To Top Of Page
This page was generated in 0.08 seconds. Powered By: Snitz Forums 2000 Version 3.4.07