how to read 'nvarchar' type data

how to read 'nvarchar' type data

Post by zhan » Fri, 12 Nov 2004 13:37:16


Hi
I have a table and have two columns is nvarchar of sql server.
but I use BDE AND tquery do not see this two columns and read them.
How to read them.
can you give me a sample?
 
 
 

how to read 'nvarchar' type data

Post by Kevin Frev » Fri, 12 Nov 2004 19:56:49

zhang,

Try using the CAST function

Select
CAST(MyNVarcharField as varchar(100)) [MyNVarCharField]

Good luck,
krf

 
 
 

how to read 'nvarchar' type data

Post by Alain Ques » Sat, 13 Nov 2004 00:40:00

In addition to Kevin's suggestion, I'll mention that the BDE doesn't support
the data types that appeared back when SQL Server 7 was released. I strongly
suggest using ADO instead of the BDE as a means of connecting Delphi and
MSSQL.

--

Alain Quesnel
XXXX@XXXXX.COM

www.logiquel.com
 
 
 

how to read 'nvarchar' type data

Post by zhan » Sat, 13 Nov 2004 10:29:39

Thank you for everyone. it is very helpful for me. thank you
"Alain Quesnel" < XXXX@XXXXX.COM >
: XXXX@XXXXX.COM ...
support
strongly