Re: mod_plsql / dad / character set problem

Sybrand Bakker <postbus@xxxxxxxxxxxxxxxxx> wrote:
On Fri, 23 Jun 2006 17:22:49 +0100, Jeremy <jeremy0505@xxxxxxxxx>
wrote:

So we feel as though we are caught between a rock and a hard place -
cananyone suggest a setting taht might support all our needs (sure I
haven't defined ALL out needs! - of course I mean something that
supports western european accented characters as well as the Euro
symbol)?

I assume (but I admit I didn't verify it) utf8 supports the euro.
On the other hand, WE8ISO8859P15 can not be converted to WE8MSWIN1252
and vice versa, so what I was trying to say: if you convert your
database to an utf characterset, allegedly a superset of normal 8-bit
charactersets, any 8-bit client should convert correctly.

Sybrand, this time your advice, which is usually well grounded and valuable,
shows that you indeed did not verify the information you gave:

- First, UTF-8 (AL32UTF8 in Oracle) will support all possible characters,
including the Euro, so your first advice to convert to this character set
is clearly a good solution.

- Second, Windoes 1252 contains all printable characters of ISO 8859-15,
so it should never be a problem to convert characters from WE8ISO8859P15
to WE8MSWIN1252.

- Third, unless your strings contain any of the dreaded Windows characters
(like UNICODE 0x2014, the em dash, or UNICODE 0x201c, left double quotation
mark), conversion from WE8MSWIN1252 to WE8ISO8859P15 will also work.

A question for the original poster:
What is the character set you are currently using?

Yours,
Laurenz Albe
.

Relevant Pages

  • Re: Unicode-based FreeBSD
    ... displaying specialised characters on the screen/tty. ... There are special Input Methods for the rest of Unicode. ... Unicode support and the FreeBSD developers see little reason to ...
    (freebsd-current)
  • Re: Unicode-based FreeBSD
    ... than any other Chinese character sets (including traditional and simplified ... The UTF-8 support in FreeBSD/Xorg is good enough for me. ... I can read/type all Unicode 4.0 characters ... There are two reasons to use any character sets other than UTF-8: ...
    (freebsd-current)
  • Re: =?ISO-8859-1?Q?Soup=E7on_of_cedilles_and_aper=E7us?=
    ... Note that most of these support only ASCII ... plus a few accented characters, ... Unicode supports, in principle, the characters of every written ... The catch is that not all newsreaders are new enough to ...
    (alt.usage.english)
  • RE: XLSX cell width - in twips?
    ... Column width measured as the number of characters of the maximum digit width ... Using the same example as above, the calculation would be ... Microsoft Online Community Support ...
    (microsoft.public.office.developer.com.add_ins)
  • [9fans] Woes of New Language Support
    ... I've been trying to add support for Sanskrit derived ... For the currently supported languages, ... characters are more or less statically mapped to the unicode ... perhaps mapped to unspecified unicode ranges?). ...
    (comp.os.plan9)