ADSM-L

weird characters in table drives

2004-08-16 08:17:54
Subject: weird characters in table drives
From: Adrian Mazarache <amazarache AT TRANSFOND DOT RO>
To: ADSM-L AT VM.MARIST DOT EDU
Date: Mon, 16 Aug 2004 15:01:56 +0300
Hello list!

I have a little problem with drives table

Here is the select statement
    
    select drive_name from drives where last_update between
current_timestamp-140 days+3 hours and current_timestamp-140 days+5
hours

It returns exactly the weird entries

DRIVE_NAME
------------------
�4▒(�....1
�4▒(�0...10
�4▒(�....2
�4▒(�
�4▒(�
�4▒(�
�4▒(�
�4▒(�
�4▒(�
�4▒(�

bla, bla

the same for the library_name

How can I del those entries with del drive ???????


Thanks.

<Prev in Thread] Current Thread [Next in Thread>