Re: changing to US7ASCII

From: Frank van Bortel <>
Date: Wed, 29 Jun 2011 15:09:39 +0200
Message-ID: <abe71$4e0b2413$524b97d2$>

On 06/29/2011 12:32 PM, Grille12 wrote:
> Hello,
> I have a rather unusual request.
> I need to test an application against a US7ASCCI oracle 11 server.
> The server is a 32 bits Oracle 11g I have no schema/databases
> installed yet so I am not concerned by any data loss.
> I do my test on a windows box. Unfortunately when installing oracle, I only
> had these charset available (us7ascii is not in there).
> AL32UTF8
> AR8ISO8859P6
> AR8MSWIN1256
> BLT8ISO8859P13
> CL8ISO8859P5
> CL8MSWIN1251
> EE8ISO8859P2
> EE8MSWIN1250
> EL8ISO8859P7
> EL8MSWIN1253
> IW8ISO8859P8
> IW8MSWIN1255
> KO16MSWIN949
> NE8ISO8859P10
> NEEISO8859P4
> TR8MSWIN1254
> VN8MSWIN1258
> WE8ISO8859P15
> WE8ISO8859P9
> WE8MSWIN1252
> So I choosed WEMSWIN1252 (default one) in the hope to be able to change it
> to US7ASCII later. Unfortunately, it does not seem to be possible.
> Is there a way to change the charset of an oracle server (sitting on
> windows) from WEMSWIN1252 to US7ASCCI?
> Or, from which of the above available charset list can I change my server to
> thanks for your help

You do realize databases store bits and bytes - not characters?

I fail to see the requirement to test against a US7ASCII database. There's no such thing as a US7ASCII database. There's no US7ASCII, for that matter - there's ASCII (as opposed to EBCDIC), which is a 7 bits code. US7ASCII implies there are other languages (ES7ASCII, anyone?) which there are none. It also implies a different number of bits code, which there is none.

There's something like environment setting which dictate the use of a certain mapping of one code point to another in order to mess up even more in the "standards" of computerland.



Frank van Bortel
Received on Wed Jun 29 2011 - 08:09:39 CDT

Original text of this message