need to pull multi-byte out of a varchar2 field

From: Ian Harisay (imharisa_at_nuskin.com)
Date: 05/20/04


Date: Wed, 19 May 2004 16:27:07 -0600
To: <dbi-users@perl.org>

Hi,

Can anyone tell me how to pull multi-byte characters out of a varchar2
field. The database is Oracle. I need to transfer these chars from one
db to another.

Thanks,

Ian



Relevant Pages

  • Re: Join performance on different data types
    ... I have two identical test tables, each with a varchar2 and number ... in Oracle is there any reason why join on number will ... The number data type had a very small advantage but you needed 100,000 ... The database data type should be whatever the data ...
    (comp.databases.oracle.server)
  • Oracle Date data type insert and format
    ... I have a Date insert that is formatted into an Oracle 9i database and ... But I had to make the Date variable a varchar2 in Oracle to get it to ... Oracle and I could get the date to insert but couldnt format it. ...
    (comp.lang.java.databases)
  • Re: call to createxml with a schema url does not create schema based xml
    ... information in xml format from the database. ... IN VARCHAR2 DEFAULT NULL, ... This capability is already built into Oracle. ...
    (comp.databases.oracle.tools)
  • Re: What so special about PostgreSQL and other RDBMS?
    ... That's exactly the link the licence agreement for the database points to when it ... comes to what wecan expect for paying support. ... > "Oracle may provide additional releases or versions of its programs ... If the requirements are volatile I'd do a long term contract detailing what ...
    (comp.lang.php)
  • A cool DBA job wanted
    ... 7, Oracle 6, Sybase, SQL Server ... Proposed proactive database monitoring through ... strategies to administer remote Oracle databases ... Trained installation and support personnel in basic ...
    (comp.databases.oracle.server)