Hello all, I'm faced with writing a procedure that converts foreign characters (occasionally found in our database in foreign names and addresses.) I've been given a "sed" command file with these special characters, that's supposed to do pattern matching and substitution. This will be a function that accepts a character string, parses, and replaces the foreign character with ASCII character, and returns the converted string. The question I have is how do I read these foreign characters into my PL/SQL procedure so that I can put my logic together? I've attached the "sed" command file so that you can exactly see what I'm referring to. Thanks very much. __________________________________________________ Do You Yahoo!? Get personalized email addresses from Yahoo! Mail - only $35 a year! http://personal.mail.yahoo.com/
s/�/ss/g s/�/a/g s/�/a/g s/�/a/g s/�/a/g s/�/a/g s/�/e/g s/�/e/g s/�/e/g s/�/e/g s/�/E/g s/�/i/g s/�/i/g s/�/i/g s/�/i/g s/�/n/g s/�/O/g s/�/o/g s/�/o/g s/�/o/g s/�/o/g s/�/o/g s/�/o/g s/�/u/g s/�/u/g s/�/u/g
