Anyone change character sets recently?
I've got a cust that wants to take a small database from US7ASCII to UTF8 I believe it
was.
It sounds like they have all the steps down pat and are pretty much ready to go, but
are there any "gotchas" they may have missed?
Will this affect the RMAN backup
Hi,
We are planning to change out database charater set from US7ASCII to UTF8
and we followed folowing steps as specified in metalink...
but still when i see the trace of controlfile it shows character set as
US7ASCII..
Do i need to do export/import to change takes place.
we have oracle 8.1.7.1.5
There's a whole spread of stuff on MetalLink about changing
character sets. There is even a utility program called 'csscan'
that scans the DB to find potential trouble spots.
In short, though, if this DB only has 7-bit ASCII characters in
in, then a switch to UTF-8 will have no immediate effect.
Try this procedure:
The extra db bounce did the trick for me. Don't ask me why. I think I
found it on MetaLink or opened a TAR.
HTH
Gerardo
SVRMGR> SHUTDOWN IMMEDIATE; -- or NORMAL
SVRMGR> STARTUP MOUNT;
SVRMGR> ALTER SYSTEM ENABLE RESTRICTED SESSION;
SVRMGR> ALTER SYSTEM SET JOB_QUEU
Gerardo,
The trick works for me also but when i try to export it shows as:
Connected to: Oracle8i Enterprise Edition Release 8.1.7.0.0 - Production
With the Partitioning option
JServer Release 8.1.7.0.0 - Production
Export done in US7ASCII character set and US7ASCII NCHAR character set
server us
Harvinder,
try setting NLS_LANG=AMERICAN_AMERICA.UTF8, then doing the export.
If NLS_LANG is not set, the default is US7ASCII as you experienced.
Refer to MetaLink Note 48644.1 and Note 15095.1
Gerardo
-Original Message-
Sent: Thursday, November 01, 2001 7:30 AM
To: Multiple recipient
NLS_LANG should be set on client, either UNIX environment variable or NT
registry entry.
I don't think there's a way to force client to use a particular character
set. This is the whole point of NLS, I think. Server should not care what
language/character set client uses, and vice versa.
Gerar
I am in the process of planning our upgrade for our 8.1.5 database to
8.1.7.4. This is the first step in upgrading all my databases to 9.2.0.4.
As part of this upgrade I am changing the character set from WE8ISO8859P1 to
UTF8. Has anyone done this change using the ALTER DATABASE CHARACTER SET
com
I have upgraded the database from 8.0.5/8.1.7 to 9.2.0.4 and changed
character set using alter database character set.
It will work without any problem. Go for it.
-Original Message-
Sent: Saturday, December 13, 2003 9:39 PM
To: Multiple recipients of list ORACLE-L
I am in the process
You can't change to UTF8 from WE8ISO8859P1, since the latter is not a subset
of UTF8.
If you were on US7ASCII, the story would be different.
You have to go with export/import.
Tanel.
- Original Message -
To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]>
Sent: Sunday, Decemb
Oracle has an internal utility to do this in place named csconv. You
have to get this from Oracle consulting. In any event, there is a
utility named csscan in your oracle home. Run it against your database
and it will tell what data if any needs to be changed. Look for UTF8
conversion docs on m
11 matches
Mail list logo
