Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.misc -> Double byte substr problem

Double byte substr problem

From: Dave Siddons <dave.siddons_at_capgemini.co.uk>
Date: Fri, 7 Aug 1998 09:55:51 +0100
Message-ID: <6qeemv$csl$1@hagen.usenet.co.uk>


Could somebody tell me the difference between substr and substrb when = used in a double byte environment, and which should be used in a double = byte environment.

The problem we've had is that when calling substr to clip a string to = fit into another field it works in a single byte environment but when = moving to double byte it truncates the return value. This implies that = substr has returned a longer string ??????? I have been told to use = substrb, but this could surely split double byte characters.

Help ....

Cheers Dave. Received on Fri Aug 07 1998 - 03:55:51 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US