Re: charset problem with '¤' ?

Sam wrote: 
I'am afraid you are right ...

Thus, i have another question: is it possible to change the charset
from WE8ISO8859P15 to
WE8ISO8859P15 or should i uninstall/install my instance ?
If it's possible "dynamically", what's the impact on the existing data
?

Thanks for your precious help
Samuel


(I assume you mean from 'p15 to something else, and that "dynamically" means "without taking the database offline")

Um, never actually done that myself. Found the following from Google on "oracle change character set":

http://oracle.ittoolbox.com/documents/document.asp?i=1601

The effects on the existing data depend on the current characterset, new characterset and whether or not the data conforms to the characterset; if you've used the nasty hack to insert data that doesn't conform to the charset then that data will almost certainly be trashed. So if you've got an ¤ in the database represented by a Euro, and you change charset to one that defines ¤ but not Euro, then that ¤ will be lost.

Definitely make sure you've got a valid backup before you start.

You shouldn't need to reinstall any software to change the characterset. You might consider creating a new database as a possible alternative to changing the current one, then use exp/imp and verify/fix the new database, then redirect the clients to the new database, then finally delete the old one if it's no longer needed. As far as I know (which admittedly isn't far in this case) it should be possible to do this without taking anything offline, whereas the above note more or less starts with a SHUTDOWN IMMEDIATE.

Dave.
.

Relevant Pages

  • Re: what characterset to use?
    ... would never corrupt your data in a WE8MSWIN1252 database character set ... WE8MSWIN1252 is a *single* byte characterset. ... If your database has been set up correctly (which is ...
    (comp.databases.oracle.server)
  • Re: WE8ISO8859P1 convert to AL32UTF8 unicode character set question
    ... AL32UTF8 database. ... If the varchar2 can be converted to target characterset and can be ... It can cause unpredictable conversion. ... UTF-16 encoded, Data retrieved from or inserted into the database must ...
    (comp.databases.oracle.server)
  • Re: what characterset to use?
    ... So if you have a database on Unix, as Unix doesn't support MSWIN1252, ... the database characterset should WE8ISO8859P15. ... So if he states it 'SOUNDS LIKE' Oracle recommends setting everything ...
    (comp.databases.oracle.server)
  • Re: Produce XML with russian text
    ... a 3.23.x MySQL version. ... To get back the data in Memo's and save them in the database there are no problems, only when I want to save them in an external file in an xml with utf-8 encoding. ... retrieving and displaying the data in a Russian characterset. ... As I see all the russian characters are saved in widestring russian characterset in the mysql database, because every of them looks excatly as before save in the Delphi Components like memo. ...
    (borland.public.delphi.thirdpartytools.general)
  • Re: Need input from Firebird users for a PostgreSQL vs Firebird comparison.
    ... a characterset per database, also not per table. ... You can, however, define charactersets and collations on a per column level. ... Firebird has VERY VERY rich character and collation support and supports ...
    (borland.public.delphi.thirdpartytools.general)