Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
yipchunyu
Yak Posting Veteran
80 Posts |
 Posted - 2007-12-12 : 01:35:54
|
| Hi all,I just get a urgent question. We created some views in our new oracle DB with some chinese characters stored in a varchar2 fields.I use openquery to access the views within a stored procedure. everything works well except those chinese characters. all the values display incorrectly. anything i can do for this? pls advice. thx in advance |
|
|
DonAtWork
Master Smack Fu Yak Hacker
2167 Posts |
Posted - 2007-12-12 : 09:44:42
|
| Too bad this is Microsoft SQL SERVER and not Oracle. Try dbforums.com[Signature]For fast help, follow this link:http://weblogs.sqlteam.com/brettk/archive/2005/05/25.aspxLearn SQL or How to sell Used CarsFor ultra basic questions, follow these links.http://www.sql-tutorial.net/ http://www.firstsql.com/tutor.htm http://www.w3schools.com/sql/default.asp |
 |
|
|
yipchunyu
Yak Posting Veteran
80 Posts |
Posted - 2007-12-12 : 20:01:23
|
| so, it means it can do nothing on the sql side? |
|
|
|
AndrewMurphy
Master Smack Fu Yak Hacker
2916 Posts |
Posted - 2007-12-13 : 09:00:19
|
| Are you talking about a MS SQL Server (as in the microsoft product) view on a Oracle table?If you have a native (oracle) view on the Oracle table does the right result show?I'd don't have Oracle experience...but maybe by answering these questions you can get others to jump in. DBForums would also be a good stopping-off point. |
|
|
|
|
|
|
unicode character in a Oracle's view