Re: Install Oracle XE with character set WE8ISO8859P1

From: Eriovaldo Andrietta <ecandrietta_at_gmail.com>
Date: Thu, 1 Oct 2009 16:39:48 -0300
Message-ID: <90b7e6bd0910011239yb91bff9jf476ecc6477bb81e_at_mail.gmail.com>



Hi all,

I solved the issue installing the OracleXE10\WesternEuropean-WE8MSWIN1252. Then my script worked fine.

 Thanks a lot for everybody that sent some message.

Regards
Eriovaldo

On Thu, Oct 1, 2009 at 11:10 AM, Rich Jesse <rjoralist_at_society.servebeer.com
> wrote:

> Hey Eriovaldo,
>
> >> Is there some reason AL32UTF8 won’t work for you?
> >>
> >> Yes, I am in trouble with this character set . I have a column that has
> 93
> >> characteres and I am getting error when inserting it in a column
> >> VARCHAR2(100). I cannot change the application. because it works fine in
> >> WE8ISO8859P1
>
> I'm not sure about creating an XE DB with another charset (this is the
> free/unsupported version of Oracle), but it sounds like your table was
> created with the columns using BYTE length semantics -- have you tried
> specifying CHAR semantics on the table create? e.g. use "VARCHAR2(100
> CHAR)" on the column?
>
> You may also want to investigate possibly using "nls_length_semantics =
> CHAR" in your init.ora to make this the default setting for the whole DB,
> with it's pluses and minuses.
>
> HTH! GL!
>
> Rich
>
>
>
> --
> http://www.freelists.org/webpage/oracle-l
>
>
>

--
http://www.freelists.org/webpage/oracle-l
Received on Thu Oct 01 2009 - 14:39:48 CDT

Original text of this message