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