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 |
|
dmurthy_g
Starting Member
2 Posts |
 Posted - 2008-07-05 : 07:25:28
|
| Hi!Any body can help me for the following issue.I need to import data from my visual foxpro database into SQL Server 2005. I am using OPENROWSET(), here the prorblem is, one of the column in Visual Foxpro Table contains Chinese Characters. But After importing into SQL table, I could not see the Chinese Characters in SQL instead it displays it as '????' likewise. Also, note, my SQL Table already contains Chinese character that are displayed as it is without any garbage characters. Only the imported values is displayed as garbage characters.Note, both SQL Server and VFP databases are both in same system.Can any one help me to solve this issue?Thanks in advance.Gandhi. |
|
|
rmiao
Master Smack Fu Yak Hacker
7266 Posts |
Posted - 2008-07-05 : 22:54:15
|
| You put them in unicode column? Maybe driver's issue? |
 |
|
|
dmurthy_g
Starting Member
2 Posts |
Posted - 2008-07-09 : 01:00:58
|
| Yes. Imported into Unicode column. Please note, the same column of the same table already contains chinese characters that are displayed without any problem. But the imported characters from VFP is the problem. Can guess why...?Thanks.111555111 |
|
|
|
rmiao
Master Smack Fu Yak Hacker
7266 Posts |
Posted - 2008-07-09 : 22:53:31
|
| Data source driver issue. |
|
|
|
|
|
|
Import from VFP : Unable to import Chinese Charact