Search the web
Sign In
New User? Sign Up
VOUGlist · Virginia Oracle User's Group
? Already a member? Sign in to Yahoo!

Yahoo! Groups Tips

Did you know...
Want to share photos of your group with the world? Add a group photo to Flickr.

Best of Y! Groups

   Check them out and nominate your group.
Having problems with message search? Fill out this form to ensure your group is one of the first to be migrated to the new message search system.

Messages

  Messages Help
Advanced
Convert diacritical (international) characters   Message List  
Reply | Forward Message #922 of 923 |
We are using:
NLS_CHARACTERSET WE8ISO8859P15,
NLS_NCHAR_CHARACTERSET UTF8
NLS_LANGUAGE AMERICAN
on 10.2.0.3.0 Oracle DB,
Does anyone know how to convert from diacritical (international)
characters to ascii in sql (view) as one of our legacy systems cannot
handle non-ascii characters?

I've tried
select name,
convert(name, 'US7ASCII', 'WE8ISO8859P15')
from UV_AD_IMAGENOW_BIODEMO

results:
SæBø,Håkon S?B?,H?kon

TIA




Wed May 21, 2008 5:47 pm

uvabob
Offline Offline
Send Email Send Email

Forward
Message #922 of 923 |
Expand Messages Author Sort by Date

We are using: NLS_CHARACTERSET WE8ISO8859P15, NLS_NCHAR_CHARACTERSET UTF8 NLS_LANGUAGE AMERICAN on 10.2.0.3.0 Oracle DB, Does anyone know how...
Bob
uvabob
Offline Send Email
May 21, 2008
6:23 pm
Advanced

Copyright © 2009 Yahoo! Inc. All rights reserved.
Privacy Policy - Terms of Service - Guidelines - Help