Hi,

I have used PB 11.2 with SQL 2000 and SQL 2005 to store and display Chinese
characters. My testing result is as follows:


PB11 + SQL 2000 / SQL 2005
DBCollation: Chinese_PRC_Stroke_CI_AS
No problem storing and displaying Chinese

PB11 + SQL 2000 / SQL 2005
DBCollation: SQL_Latin1_General_CP1_CI_AS
Store character as ???

I google adn try to use String() and Blob() method to convert unicode to
ANSI and I also try to set DisableUnicode=1 in SQLCA.DBParam. All the
methods can't solve the problem.

Does anyone know if there is any solution? Is that PB11 must use a DB with
non-ASCII collation?