David wrote:
[snip]
>
>>Test it with a different character set setting
>>on the testing1 side. Remeber, testing1 is client
>>as well as server: if you just use sql on the testing1
>>sode, you should see the same behaviour (connect to
>>testing2, as do a select * from testing_chinese; )
>
>
> when i query in testing2, all characters can be seen (with select * from
> testing_chinese)
Not what I said. reread above: from testing1!
>
>
> I don't know whether there ara some setting that I should set. For 8i,
> should it also display all characters in testing1? And what is the
> differences between UTF8 and AL32UTF8 in 9i?
It's in the manuals on http://docs.oracle.com
>
>
>>If you store them in another characterset database,
>>it all makes sens - and I'll go back to the first
>>reaction: define your table with: varchar2(10 CHAR),
>>and it will work
>>
Have you tried that?!?
--
Regards,
Frank van Bortel
Received on Sun Feb 15 2004 - 10:33:27 CST
