Board index » delphi » Accesing nvarchar in SQL Server

2005-03-24 08:02:11 PM
delphi210
Hi all!
I'm trying to access a table in a SQL Server using D5 and BDE.
I get access to the table, but I can only see the Integer fields. The fields
of the type nvarchar are not visible!!!
Can someone tell me why? Is a special setting in BDE needed??
Thanks a lot for any suggestions!
Marco
 

You can't access nvarchar fields using the BDE.
You will need to use the TSql "Convert(char(xxxx),yyyyy)" function to select the field.
Switch to using ADO instead since the BDE is no longer supported.