Re: Character Sets - 2 different kinds, same server

2002-11-12 Thread Yechiel Adar
1) You can have two databases with different character sets in the same computer. you may have problems running local jobs, but I do not know Solaris to comment on this. 2) according to metalink doc#: 119164.1, UTF8 is a superset of US7ASCII so you can convert your database to use UTF8 without

Character Sets - 2 different kinds, same server

2002-11-11 Thread Eric Richmond
Is it possible to have two different databases on the same server using two different kinds of character sets (one would be UTF8 NCHAR and the other would be US7ASCII)? How do you create the databases with two different character sets (is it an init parameter)? If that is not possible and

RE: Character Sets - 2 different kinds, same server

2002-11-11 Thread Ron/Sarah Yount
Character set are defined the database level. If you have two different databases, then you can have any two different character sets you wish. This is generally defined at the time you run the create database... statement. Understand of course that in your scenario there would be limits on