Cannot get Chinese Characters from SQL server with ADO 
Author Message
 Cannot get Chinese Characters from SQL server with ADO

Dear All
I am developing an application with VB 6.0 and SQL Server 7.0.  The
application will edit data of table in SQL server with ADO Data Control 6.0
and DataGrid Control 6.0.  However, the field which contains chinese
characters will be shown as blank and the fields following will be moved
forward by one field.
For example, the data in SQL server is shown as
Record_id    Client_Chinese_Name    Client_English_Name    Sex    Age
1                    XXX                              David
M        27
2                    YYY                              Peter
M        34

The data shown in DataGrid will be
Record_id    Client_Chinese_Name    Client_English_Name    Sex    Age
1                                                          M
2                                                          M

I have been working on this problem for a few days and I still don't know
how to solve the problem.  I really hope someone can help me out.
Thank you


Sun, 14 Sep 2003 14:56:39 GMT  
 [ 1 post ] 

 Relevant Pages 

1. chinese character problem in ADO

2. Using Chinese Character in SQL statment, How?

3. SQL Server (ADO) Can't Insert Strings Longer Then 30 characters

4. Getting RETURN_VALUE from SQL Server to ADO

5. Getting tables name from SQL Server via ADO

6. Getting the counter value after an addnew-SQL SERVER 2000/ADO

7. VB Sql Server Via ADO Problem: [Microsoft][ODBC Sql Server Driver]

8. Access 2000 VBA/SQL - cannot create pseudo-index on linked SQL Server table

9. ADO recordset's memo field gets truncated at 254 characters

10. Chinese characters?

11. How to add Chinese Characters to Subject.

12. Chinese Character In Access


Powered by phpBB® Forum Software