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 -> Re: vowels in oracle

Re: vowels in oracle

From: DA Morgan <damorgan_at_psoug.org>
Date: Fri, 10 Aug 2007 08:41:19 -0700
Message-ID: <1186760478.994578@bubbleator.drizzle.com>


Frank van Bortel wrote:
> -----BEGIN PGP SIGNED MESSAGE-----
> Hash: SHA1
>
> DA Morgan wrote:

>> Frank van Bortel wrote:
>> DA Morgan wrote:
>>>>> Terry Dykstra wrote:
>>>>>> So how do you deal with the Dutch 'ij' combination, somewhat similar
>>>>>> to the 'y'.
>>>>> By using REPLACE.
>> And the real question is, of course: how do you tell
>> replace to treat 'ij' (actually: "ÿ" (0x0152))
>> as a single character?

>
>> Well if you've got the right character set ... you've answered
>> your own question. <g>

>
> The question is: how to handle the two characters "ij"
> as a single character; not many keyboards support "ÿ",
> so "ij" is used.
>
> This situation can be extended to more languages: German
> has the Ringel-s, (0x0225 "ß"), now often written
> as "sz" (think it's even official now - native Germans
> around, that can clear that?)
> - --
> Regards,
> Frank van Bortel
>
> Top-posting is one way to shut me up...
> -----BEGIN PGP SIGNATURE-----
> Version: GnuPG v1.4.1 (MingW32)
>
> iD8DBQFGvDMpLw8L4IAs830RAjpKAKCHk8KRh9/cn8qzuhzHzjl+kPQcNgCffUTF
> PmnPErO/r3vbxNjjswIRjBc=
> =5TY+
> -----END PGP SIGNATURE-----
Any chance you could use a HEXTO something function to convert to a value that could be evaluated in the form of the CHR function?
-- 
Daniel A. Morgan
University of Washington
damorgan_at_x.washington.edu (replace x with u to respond)
Puget Sound Oracle Users Group
www.psoug.org
Received on Fri Aug 10 2007 - 10:41:19 CDT

Original text of this message

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