Hi everyone,



Can someone help me please

I am trying to save and retrieve Chinese Chars from the database



This is my current table format

CREATE TABLE "PRODUCTTABLE" (

"BARCODENUMBER" VARCHAR(13) NOT NULL PRIMARY KEY,

"POSDESCRIPTION" VARCHAR(20),

"PRINTINKITCKEN" INTEGER,

"KITCHENDESCRIPTION_ENG" VARCHAR(40),

"KITCHENDESCRIPTION_OTHER" VARCHAR(100) CHARACTER SET UTF8,

"SUPPLIERID" VARCHAR(10),

"SUPPLIERNAME" VARCHAR(40),

"SUPPLIERITEMCODE" VARCHAR(40),

"STOCKCONTROL" INTEGER,

"CURRENTSTOCK" INTEGER,

"REORDERPOINT" INTEGER,

"ORDERINQTY" INTEGER,

"PACKSIZE" INTEGER,

"MSACTIVE" INTEGER,

"MSCODE" VARCHAR(13),

"OPTIONSALLOWED" INTEGER,

"OPTIONCODE" VARCHAR(13),

"COSTPRICE" VARCHAR(13),

"UNITCOST" VARCHAR(13),

"MARKUPVALUE" VARCHAR(13),

"SALEGROUP" VARCHAR(13),

"PRICETYPE" VARCHAR(13),

"SETPRICE_HALFPRINT" VARCHAR(13),

"SETPRICE_HALFPINT_VAT" VARCHAR(1),

"SETPRICE_PINT" VARCHAR(13),

"SETPRICE_PINT_VAT" VARCHAR(1),

"SETPRICE_RETAILPRICE" VARCHAR(13),

"SETPRICE_RETAILPRICE_VAT" VARCHAR(1),

"EATIN_HALFPINT" VARCHAR(13),

"EATIN_HALFPINT_VAT" VARCHAR(1),

"EATIN_PINT" VARCHAR(13),

"EATIN_PINT_VAT" VARCHAR(1),

"EATIN_RETAILPRICE" VARCHAR(13),

"EATIN_RETAILPRICE_VAT" VARCHAR(1),

"EATOUT_HALFPINT" VARCHAR(13),

"EATOUT_HALFPINT_VAT" VARCHAR(1),

"EATOUT_PINT" VARCHAR(13),

"EATOUT_PINT_VAT" VARCHAR(1),

"EATOUT_RETAILPRICE" VARCHAR(13),

"EATOUT_RETAILPRICE_VAT" VARCHAR(1)

);

I can change the format NOW as this application is in development
(programming language VB6 and interface is ODBC)



I can display when adding a new product the Chinese chars but when I recall
it from the database I get ????

Am I setting the field up wrong in the database?



Andy



[Non-text portions of this message have been removed]