Storing foreign chars in Oracle DB 9204...

Reply Subscribe

Thread Tools

Search this Thread

Jan 14, 2004 | 11:22 AM

sjah555

Thread Starter

Scooby Regular

Joined: Sep 2001

Posts: 312

Likes: 0

For example... " û " - any ideas on an easy way to do this ?

Your help is much appreciated...

Ta,
-Sal-

Jan 14, 2004 | 03:41 PM

stu200

Scooby Regular

iTrader: (1)

Joined: Apr 2001

Posts: 531

Likes: 0

Don't use Oracle myself, but a guess would be to create your database and specify a Unicode codepage (UTF-8 or UTF-16) and then, from a Unicode enabled client, stuff your umlauts in to your heart's content.

... or click here ...

Jan 14, 2004 | 03:51 PM

sjah555

Thread Starter

Scooby Regular

Joined: Sep 2001

Posts: 312

Likes: 0

Thanks Stu...

Only problem is existing db created in char set WE8ISO8859P1

Anyhow, I'll take a quick look on metalink and here:
http://otn.oracle.com/documentation/index.html

-Sal-

Jan 14, 2004 | 04:02 PM

stu200

Scooby Regular

iTrader: (1)

Joined: Apr 2001

Posts: 531

Likes: 0

No idea if it's any help, but I put "database codepage" into the site search and it came back with an article titled Use the Character Set Scanner to Migrate a Database to support Unicode