Joe Au


I install VFP 8.0 English version into a Windows Server 2003 Chinese version with SQL Server 2005 English version.

Within the SQL Server, I can save Chinese character into a column as it is defined as nchar.

When I run a VFP application, I cannot save Chinese character and it becomes as .

The VFP application connects the SQL Server through ODBC data source.

I have tried both enable and disable the "Perform translation for character data" on the ODBC, but I still cannot save Chinese character.

How can I fix it

Thanks,

Joe.




Re: Cannot save Chinese character

AlexBB


Joe Au wrote:

I install VFP 8.0 English version into a Windows Server 2003 Chinese version with SQL Server 2005 English version.

Within the SQL Server, I can save Chinese character into a column as it is defined as nchar.

When I run a VFP application, I cannot save Chinese character and it becomes as .

The VFP application connects the SQL Server through ODBC data source.

I have tried both enable and disable the "Perform translation for character data" on the ODBC, but I still cannot save Chinese character.

How can I fix it

Thanks,

Joe.

Naturally, I have never done something like this but if there is an option, I would try OLEDB driver instead: .NET Framework Data Provider for OLEDB.







Re: Cannot save Chinese character

dni

What is ascii value for " "

asc(" ")







Re: Cannot save Chinese character

Tamar E. Granor

Are you trying to work with Unicode characters VFP doesn't support Unicode, but it does support double-byte character sets.

Tamar