I use a VB6, and SQL Server 2000
There are Two Database of SQL Server 2000 on Seperate Server.
First Database have Japanese_CI_AS Collation
Second Database have Latin1_General_CI_AS.
Problem is That When I Execute a Query Using Vb6 With ADO On Second Database, its Ok, but When Same Query Running On First Database with Jap_CI_AS, then It give Error:
String or binary data would be truncated.
The statement has been terminated.
The Query Contain Unicode Value for A Column and The All String Column Defined in Table As Char Datatype.
insert into Recv_info_Tmp(prod_section_c, sub_section_c, slip_no, Order_no, product_no, cusdesch_c1, cusdesch_c2 ) values ('235400', '00', '10003', 'TEST0123451', 'ZZZZＫZ999999999999', '9993', '93')
The "K" in Between Z for Product_no Column is Unicode character. and when String made the "K" is converted to "‚j". The Length of Product_No col is CHar(18)
Please Solve My Problem as soon as possible.
For More Detail send mail to firstname.lastname@example.org