Re: Delphi and NCHAR - how?

Leonid Belov (white@intek.spb.su) wrote: : Hi all, : I have a problem in Delphi 1.0.2 <-> Informix Online 7.1 interaction. : Delphi cannot recognize NCHAR/NVARCHAR data types : (message "invalid data type in column"). : Is there any method to make it operational? : Any help would be appreciated. : Leonid : Hi Leonid, I think you have to set environment variables DBNLS=2 and COLLCHAR=1. Setting COLLCHAR to 1 means that nchar columns sent to the application are converted to char and any char columns sent to the server are converted to nchar. I hope this helps. Mirek -- ================================= Miroslav Lorenc Database Administrator Software Applications and Systems Internet: Miroslav.Lorenc@sasprg.cz Tiskarska 10/257 108 28 Prague 10 Tel: +42 2 705134 Czech Republic Fax: +42 2 705128