Skip to Content
Former Member
Mar 17, 2014 at 05:01 PM

Powerbuilder and chinese Characters


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


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


@shop_no SMALLINT,

@trading_date DATETIME,

@stock_message NVARCHAR(MAX)

and the table is defined as


[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)