| CHAR and VARCHAR2 problem [message #100652] |
Tue, 01 April 2003 02:40  |
allen
Messages: 15
Registered: August 2000
|
Junior Member |
|
|
Hi,
First,I introduce my computer environment.
1.PII 333Mhz /OS:win NT 4.0 SP6a
2.Front end:Powerbuilder 6.5 web.pb(web solution)
ODBC : Oracle8 ODBC Drive 8.00.03.00/SQORA32.DLL 06/01/97
3.back end:sun 3000,oracle 8.00.04
Then,I want to change the ap serevr to win2000 server on the new computer.However I use all kind of combination,it could always cause memory utility rate to increase continually until crash.
I use odbc version 8.1.7.8b and 8.1.7 client to connect oracle DB version 8.0.4 now.
It brings other problem,the original verion 8.0.3 seems to trim table data in advance,but 8.1.7.8b can not trim table data return from DB.
It cause retrieve field data like 'aaa ' to contain empty chars.
Maybe I can tranfer CHAR to VARCHAR2 for all table's data type and clean empty chars for DB by many processes and edit my program. But it looks like difficult and perplexed to do that.
Is there any other solution or any setting about ODBC 8.1.7.8b Driver to solve it.
thanks a lot.
|
|
|
|
| Re: CHAR and VARCHAR2 problem [message #100659 is a reply to message #100652] |
Sat, 05 April 2003 00:08  |
RAVISHANKARPILLALA
Messages: 1
Registered: April 2003
|
Junior Member |
|
|
HAI,
SELECT 'UPDATE ' || TABLE_NAME||' SET '||COLUMN_NAME||' = TRIM('||COLUMN_NAME||');' FROM
USER_TAB_COL WHERE TABLE_NAME=
' AND DATA_TYPE LIKE 'VARCHAR%'
RUN THE ABOVE QUERY U WILL GET SET OF UPDATE STATEMENTS.COPY THOSE UPDATE STATEMENTS AND RUN IT AGAIN.
THANKS
RAVI SHANKAR PILLALA
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
