-
question about insert into nvarchar2 column
Just wonder, when insert a value to nvarchar2 column, do we always need to put N' ' there?
My tests show ---
For Oracle 8.1.7(character set is not unicode), I have to put N'' there.
For Oracle 9.2.0 server, it works even if I don't put it there. However, I have unicode characterset on this server, so I don't know if that because it's a 9i server, or because that server uses unicode character set.
Oracle 9.2.0 Globalization guide does mentioned the implicit conversion between different characters (which make me feel we don't have to put N'' in 9i). Can somebody make it sure for me? Thanks!
http://download-west.oracle.com/docs...h6.htm#1011117
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|