Results 1 to 3 of 3
  1. #1
    Join Date
    Jul 2011
    Posts
    2

    Unhappy Unanswered: Converting from NVARCHAR2 to VARCHAR2

    Looking at the cast charts, it appears that the only way to convert between these two is to CAST to RAW then CAST to VARCHAR2. However, anything with a string of text ultimately fails.

    So what is the recommended process for doing this type of conversion .. and doing it within an Oracle SELECT statement?

  2. #2
    Join Date
    Jun 2003
    Location
    Toronto, Canada
    Posts
    5,516
    Provided Answers: 1
    I don't think a simple CAST can help you - you will need to convert character data from one codeset to another. Look at the CONVERT() function.

  3. #3
    Join Date
    Jul 2011
    Posts
    2
    Well I finally found a very simple solution:

    to_char( field )

    That did it for me.

Tags for this Thread

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •