Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
DBCS data in dbf to SQL Server NVARCHAR
Message
From
06/03/2007 11:01:21
 
General information
Forum:
Visual FoxPro
Category:
Client/server
Environment versions
Visual FoxPro:
VFP 9 SP1
OS:
Windows XP SP2
Network:
Windows 2000 Server
Database:
MS SQL Server
Miscellaneous
Thread ID:
01200567
Message ID:
01201054
Views:
29
Hi,
I tried

1. STRCONV(myValue, 5) : SQL Server shown as funny character and only first character appear.

2. CREATEBINARY(STRCONV(STRCONV(myvalue,9),12)) : SQL Server shown funny character

3. Change language from regional and do direct import without conversion: SQL Server shown as chinese words.

I havent try other language.
I am not the most powerful man in this world.
I am not the worst man in this world either.
I just as same as all of you.
I still need to learn from my mistakes...
Previous
Reply
Map
View

Click here to load this message in the networking platform