Board index » delphi » Accesing nvarchar in SQL Server

Accesing nvarchar in SQL Server

2005-03-24 08:02:11 PM
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!

Re:Accesing nvarchar in SQL Server

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.