N prefix in SQL Queries for MFC DAO (using Visual Studio 2003)
- From: nikhil.soneja@xxxxxxxxxxxxxxxxxxxx
- Date: 4 Dec 2006 23:04:58 -0800
Hi,
Just came across a peculiar problem, couldn't find anything on the web
documenting it. Am developing an ActiveX/COM dll which is to handle
data from an SQL Server 2000 DB; due to a new requirement, have to
handle an Arabic database as well, so I attempted adding the N prefix
on all strings in queries to indicate unicode (as I've done in queries
sent through C# as well as in Enterprise Manager), however DAO doesn't
seem to be recognizing it as valid syntax, I reckon its probably
outdated, and yes I really should be using ADO, but before I go
porting my code to ADO, was wondering if I'm correct in my assumption
that the cause is DAO. Anyone come across this situation before?
Thanks,
Nikhil
.
- Follow-Ups:
- Re: N prefix in SQL Queries for MFC DAO (using Visual Studio 2003)
- From: AliR \(VC++ MVP\)
- Re: N prefix in SQL Queries for MFC DAO (using Visual Studio 2003)
- Prev by Date: End of OnSize event
- Next by Date: Re: Zoom in/ Zoom out images
- Previous by thread: End of OnSize event
- Next by thread: Re: N prefix in SQL Queries for MFC DAO (using Visual Studio 2003)
- Index(es):
Relevant Pages
|
