Re: WE8ISO8859P1 convert to AL32UTF8 unicode character set question
From: Frank van Bortel <frank.van.bortel_at_gmail.com>
Date: Mon, 20 Apr 2009 20:21:04 +0200
Message-ID: <bf117$49ecbd11$524b9d64$15954_at_cache4.tilbu1.nb.home.nl>
Laurenz Albe wrote:
> Frank van Bortel wrote:
>
> You can choose to ignore and circumvent the character set
> awareness of a database system and have your application handle
> these issues. Oracle is pretty lax in that respect and will
> let you do what you want.
>
> Three disadvantages:
> - You might to reinvent the wheel.
> - You can get into trouble if the requirements change and
> the database will need to be accessed and used in new
> ways (JDBC, database link to AL32UTF8 database, ...).
> - Oracle utilities may scream at you or behave in
> surprising ways if the database does not contain what
> they think it does.
>
> Yours,
> Laurenz Albe
>
>
I wanted to share this
http://www.oracle.com/technology/tech/globalization/htdocs/nls_lang%20faq.htm
Date: Mon, 20 Apr 2009 20:21:04 +0200
Message-ID: <bf117$49ecbd11$524b9d64$15954_at_cache4.tilbu1.nb.home.nl>
Laurenz Albe wrote:
> Frank van Bortel wrote:
>> No need for that - a database stores whatever you throw at it. >> I can store "special" characters in a US7ASCII database. >> And retrieve them. >> >> Provided the tool set cat actually display your "special" >> characters...
>
> You can choose to ignore and circumvent the character set
> awareness of a database system and have your application handle
> these issues. Oracle is pretty lax in that respect and will
> let you do what you want.
>
> Three disadvantages:
> - You might to reinvent the wheel.
> - You can get into trouble if the requirements change and
> the database will need to be accessed and used in new
> ways (JDBC, database link to AL32UTF8 database, ...).
> - Oracle utilities may scream at you or behave in
> surprising ways if the database does not contain what
> they think it does.
>
> Yours,
> Laurenz Albe
>
>
I wanted to share this
http://www.oracle.com/technology/tech/globalization/htdocs/nls_lang%20faq.htm
-- Regards, Frank van BortelReceived on Mon Apr 20 2009 - 13:21:04 CDT