Powerbuilder and chinese Characters

[Former Member]

I am using powerbuilder 12.5.2 Build 5006 with a MSSQL Server 2008 SP2 database.Version 10.0.5500.0

The connection to the databse uses ODBC and the connect string is

DBParm=ConnectString='DSN=StarKISHK_Dev;UID=;PWD=;APP=%app%;WSID=%wsid%',ConnectOption='SQL_INTEGRATED_SECURITY,SQL_IS_ON',PBCatalogOwner='dbo',StripParmNames='Yes',DisableBind=1

I can retreive and dsiplay Chinese characters, howvere if I enter Chinese characters in a datawindow, and perform an update, only question marks are saved to the database. The update uses a stored procedure.

The datawindow column is called stock_message and is defined as a string, the parameters for the stored procedure are

[usp_update_day_stock_message]

    @shop_no            SMALLINT,

    @trading_date        DATETIME,

    @stock_message        NVARCHAR(MAX)

and the table is defined as

[dbo].[trading_conditions](

    [shop_no] [smallint] NOT NULL,

    [trading_date] [datetime] NOT NULL,

    [stock_message] [nvarchar](max) NULL

What is preventing the Chinese characters being saved properly?

(I saw an old post saying set disablebind=0 in the connection string but that didn't work)

[former_member190719]

Actually, the better place to ask a technical question like this is over in the PowerBuilder Developer Center.  This area is more for people who are interesting in finding out more about the product, not the folks who are already using it.  As a result, most of the developers are over in the developer center, not here.