Access Crashes with CONTAINS in ServerFilter

Please excuse the crosspost from the Access forms group.
We are trying to implement a keyword search functionality in an Access 2002
project. We have set up SQL Server 2000 for full-text searching. Testing
SQL Server through Query Analyzer produces the expected results.
In a search tab on a form in an Access project, we dynamically construct a
WHERE clause for a subform. A keyword search is implemented by adding the
CONTAINS predicate to the ServerFilter string.
Once constructed, the ServerFilter is then applied to the subform and the
subform requeried to display the search's results. In testing, when we enter
criteria into the keyword field, Access crashes with no preceeding error
message. The crash occurs on the Requery statement for the subform. On the
screen, the subform fields all go blank, one gets the #Name error appearing
in it, and then the "Access has encountered . . . " message appears. An
example of an exact ServerFilter string producing the error is
"CONTAINS(*,'data')".
The documentation with Access says that the ServerFilter property is a WHERE
clause (without the WHERE). Is there an undocumented limitation that
predicates like CONTAINS cannot be used in the ServerFilter string, or am I
missing something? Any help appreciated.
can you run profiler on SQL Server to see what the sql command access is
running on SQL Server is.
if you can run this command in query analyzer, the problem is not with SQL
Server FTS, but rather with Access.
Hilary Cotter
Looking for a book on SQL Server replication?
http://www.nwsu.com/0974973602.html
"Paul Smith" <PGCS@.online.nospam> wrote in message
news:AF65C9BB-3C00-4A95-B71B-95C6542CB6A1@.microsoft.com...
> Please excuse the crosspost from the Access forms group.
> We are trying to implement a keyword search functionality in an Access
2002
> project. We have set up SQL Server 2000 for full-text searching.
Testing
> SQL Server through Query Analyzer produces the expected results.
> In a search tab on a form in an Access project, we dynamically construct a
> WHERE clause for a subform. A keyword search is implemented by adding the
> CONTAINS predicate to the ServerFilter string.
> Once constructed, the ServerFilter is then applied to the subform and the
> subform requeried to display the search's results. In testing, when we
enter
> criteria into the keyword field, Access crashes with no preceeding error
> message. The crash occurs on the Requery statement for the subform. On
the
> screen, the subform fields all go blank, one gets the #Name error
appearing
> in it, and then the "Access has encountered . . . " message appears. An
> example of an exact ServerFilter string producing the error is
> "CONTAINS(*,'data')".
> The documentation with Access says that the ServerFilter property is a
WHERE
> clause (without the WHERE). Is there an undocumented limitation that
> predicates like CONTAINS cannot be used in the ServerFilter string, or am
I
> missing something? Any help appreciated.
|||The culprit is definitely Access. About that there was really no question.
I am hoping someone who uses SQL Server full text searching may have
encountered this problem with Access and know how to resolve it. Access is
producing a string of SQL SELECT statements (54 to be exact) which are in
the form SELECT * FROM "dbo"."tablename" WHERE (CONTAINS (*, 'string')).
With each successive call by Access, an additional set of parentheses is
added around the CONTAINS predicate.
"Hilary Cotter" <hilaryk@.att.net> wrote in message
news:O47ozRtiEHA.2012@.TK2MSFTNGP09.phx.gbl...[vbcol=seagreen]
> can you run profiler on SQL Server to see what the sql command access is
> running on SQL Server is.
> if you can run this command in query analyzer, the problem is not with SQL
> Server FTS, but rather with Access.
> --
> Hilary Cotter
> Looking for a book on SQL Server replication?
> http://www.nwsu.com/0974973602.html
>
> "Paul Smith" <PGCS@.online.nospam> wrote in message
> news:AF65C9BB-3C00-4A95-B71B-95C6542CB6A1@.microsoft.com...
> 2002
> Testing
a[vbcol=seagreen]
the[vbcol=seagreen]
the[vbcol=seagreen]
> enter
> the
> appearing
> WHERE
am
> I
>
|||Paul,
To the best of my knowledge, no one has reported a similar problem via this
newsgroup and I've been replying and monitoring it since it's inception in
late 2000. I'd recommend that you open a support case with Microsoft PSS SQL
Server &/or Access support to see if they have had past customers who have
encountered this possible bug. If you do, could you post back here what the
result was?
Other than the multiple additional set of parentheses that Access is adding,
can you issue a SELECT * FROM "dbo"."tablename" WHERE (CONTAINS (*,
'string') via Access and if so do you get the same error? Is your goal to
issue SQL FTS queries to SQL Server as the backend to an Access front-end?
Thanks,
John
"Paul Smith" <paulgcsmith@.hotmail.com> wrote in message
news:u7pEKwtiEHA.2696@.TK2MSFTNGP11.phx.gbl...
> The culprit is definitely Access. About that there was really no
question.
> I am hoping someone who uses SQL Server full text searching may have
> encountered this problem with Access and know how to resolve it. Access
is[vbcol=seagreen]
> producing a string of SQL SELECT statements (54 to be exact) which are in
> the form SELECT * FROM "dbo"."tablename" WHERE (CONTAINS (*, 'string')).
> With each successive call by Access, an additional set of parentheses is
> added around the CONTAINS predicate.
> "Hilary Cotter" <hilaryk@.att.net> wrote in message
> news:O47ozRtiEHA.2012@.TK2MSFTNGP09.phx.gbl...
SQL[vbcol=seagreen]
construct[vbcol=seagreen]
> a
> the
> the
we[vbcol=seagreen]
error[vbcol=seagreen]
On[vbcol=seagreen]
An
> am
>
|||For anyone else who might encounter this problem: we seem to have resolved
the problem here. One of our developers noticed that we had gotten angled
quotation mark characters rather than the typical straight apostrophe as a
string delimiter. We aren't quite sure how this happened, but once this was
corrected, things seemed to start working correctly.
"John Kane" <jt-kane@.comcast.net> wrote in message
news:%23Ic$xQxiEHA.2812@.tk2msftngp13.phx.gbl...
> Paul,
> To the best of my knowledge, no one has reported a similar problem via
this
> newsgroup and I've been replying and monitoring it since it's inception in
> late 2000. I'd recommend that you open a support case with Microsoft PSS
SQL
> Server &/or Access support to see if they have had past customers who have
> encountered this possible bug. If you do, could you post back here what
the
> result was?
> Other than the multiple additional set of parentheses that Access is
adding,[vbcol=seagreen]
> can you issue a SELECT * FROM "dbo"."tablename" WHERE (CONTAINS (*,
> 'string') via Access and if so do you get the same error? Is your goal to
> issue SQL FTS queries to SQL Server as the backend to an Access front-end?
> Thanks,
> John
>
> "Paul Smith" <paulgcsmith@.hotmail.com> wrote in message
> news:u7pEKwtiEHA.2696@.TK2MSFTNGP11.phx.gbl...
> question.
> is
in[vbcol=seagreen]
is[vbcol=seagreen]
> SQL
Access[vbcol=seagreen]
> construct
adding[vbcol=seagreen]
and[vbcol=seagreen]
> we
> error
> On
> An
a[vbcol=seagreen]
that[vbcol=seagreen]
or
>

Access - SQL 2005

Hi Guys/Girls...
I'm using SQL 2005 integration services to copy data from an existing access
database. The access datbase contains a field, with the type of NTEXT. I am
trying to write the corresponding data to a table with a nvarchar(8000)
field.
I'm also trying to use the 'Data Conversion' data flow transformation,
however I am unsure what to convert the NTEXT to? I've tried a variety of
supported types, however I always seem to get an error stipulating that the
output stream stipulated does not support the NTEXT conversion.
Has anybody tried anything like this yet?
Thanks,
Justin> I'm using SQL 2005 integration services to copy data from an existing
> access database. The access datbase contains a field, with the type of
> NTEXT.
Access does not have a data type called NTEXT. This is gong to be MEMO in
Access, and I think Integration Services is telling you to use NTEXT in SQL
Server. I am going to suggest you use NVARCHAR(MAX) as the destination data
type.
A|||Hi Aaron,
I do not wish to import into a NTEXT field in my SQL2005 database, but would
prefer that Integration Services do the implicit conversion to a
Varchar(8000) using the 'Data Conversion' data flow transformation.
Thanks,
Justin
"Aaron Bertrand [SQL Server MVP]" <ten.xoc@.dnartreb.noraa> wrote in message
news:enxdpaq%23FHA.984@.tk2msftngp13.phx.gbl...
> Access does not have a data type called NTEXT. This is gong to be MEMO in
> Access, and I think Integration Services is telling you to use NTEXT in
> SQL Server. I am going to suggest you use NVARCHAR(MAX) as the
> destination data type.
> A
>

accented characters and ñ's

Hi,
I have a problem in a rss script, when i try to create a folder name that
contains accented charactes or ñ's, the folder is created WITHOUT these
characters.
Example:
rs.CreateFolder("�andú", "/", Nothing)
I run the script and then i go to the report manager and the folder created
is "and"
If i create the folder manually with the report manager it works OK, but i
need the script.
Even when i print this name through the console:
Console.WriteLine("�andú") ' Shows: and
This prints fine in a common vb.net console application, someone knows what
the problem ?
Thanks in advanceThis repros when you save the .RSS file as ANSI but when you save the .RSS
file as Unicode, it works.
Brian Welcker
Group Program Manager
Microsoft SQL Server
This posting is provided "AS IS" with no warranties, and confers no rights.
"Diego Belay" <Diego Belay@.discussions.microsoft.com> wrote in message
news:B63EB827-B112-409E-BFF9-7BFE8B43E23C@.microsoft.com...
> Hi,
> I have a problem in a rss script, when i try to create a folder name that
> contains accented charactes or ñ's, the folder is created WITHOUT these
> characters.
> Example:
> rs.CreateFolder("Ñandú", "/", Nothing)
> I run the script and then i go to the report manager and the folder
> created
> is "and"
> If i create the folder manually with the report manager it works OK, but i
> need the script.
> Even when i print this name through the console:
> Console.WriteLine("Ñandú") ' Shows: and
> This prints fine in a common vb.net console application, someone knows
> what
> the problem ?
> Thanks in advance
>|||it works now, thanks!
"Brian Welcker [MS]" wrote:
> This repros when you save the .RSS file as ANSI but when you save the .RSS
> file as Unicode, it works.
>
> --
> Brian Welcker
> Group Program Manager
> Microsoft SQL Server
> This posting is provided "AS IS" with no warranties, and confers no rights.
>
> "Diego Belay" <Diego Belay@.discussions.microsoft.com> wrote in message
> news:B63EB827-B112-409E-BFF9-7BFE8B43E23C@.microsoft.com...
> > Hi,
> > I have a problem in a rss script, when i try to create a folder name that
> > contains accented charactes or ñ's, the folder is created WITHOUT these
> > characters.
> >
> > Example:
> > rs.CreateFolder("�andú", "/", Nothing)
> >
> > I run the script and then i go to the report manager and the folder
> > created
> > is "and"
> > If i create the folder manually with the report manager it works OK, but i
> > need the script.
> >
> > Even when i print this name through the console:
> >
> > Console.WriteLine("�andú") ' Shows: and
> >
> > This prints fine in a common vb.net console application, someone knows
> > what
> > the problem ?
> >
> > Thanks in advance
> >
> >
>
>

Absolute position or location of report table.

Hello,

I have a report that prints cards for customers. The body of the report contains an address box, letter body, followed by a table that contains all the people to be printed on the cards. If the number exceeds 6 people, another page is to be printed, with no address or letter body, but the table with the remainder of the people on it.

I have been able to get everything to work except for the location of the table on the subsequent pages. They do not appear at the bottom as they do on the first page, but at the top of the page. I've tried using a rectangle as a container for the table, with no luck.

I seem to remember doing this in the past, but as projects get shelved for an extended period of time, the technical knowledge tends to fade.

Any suggestions would be greatly appreciated. Thanks

Have you tried setting both PrintOnFirstPage and PrintOnLastPage to true? This is described here:

http://msdn2.microsoft.com/en-us/library/aa178940(SQL.80).aspx

If you don't want header labels to show on the second and subsequent pages, then put them all inside of one container element and set its Hidden property to true if the PageNumber is > 1. This way the header area will still be rendered but everything in it is invisible.

sluggy

about messges in microsoft sql express

:eek: :eek: :eek: :eek:
Msg 156, Level 15, State 1, Line 6
Incorrect syntax near the keyword 'contains'.
Msg 102, Level 15, State 1, Line 8
Incorrect syntax near ')'.

i am getting error messages like this.
I want to know what this message really
mean i.e list of messages corresponding to numbers......The SQL engine uses only the error numbers internally. Those are what the engine know about, and are how it complains about "bad code" that it receives from the SQL client. The error message displayed below the Msg line contains a description of the error in the current locale (in this case, essentially a human language like English, Spanish, French, etc).

The process of getting the text description is simply a table lookup, there's no "magic" associated with it. The table of error messages changes constantly, usually with every service pack.

-PatP|||they are stored in sysmessages:

select * from sysmessages where error in (102,156)

About MCDBA

Hi,
I knew the MCDBA contains 3 required exams and 1 elective
exam.
1) Can someone tell me, if I am not go to the training
classes, just buy books such as MCSE Training Kit:
Microsoft SQL Server 2000 System Administration, Database
Design and Implementation, etc. is possible to pass exams?
2) Those MCSE Training Kit books contain self-test? If
they don't contain self-test, where I can find them?
Thanks,
Jennyhttp://www.transcender.com/
Best self-test stuff out there back when I was taking certification exams
Kevin Hill, MCSE
President
3NF Consulting
www.3nf-inc.com/NewsGroups.htm
"Jenny" <anonymous@.discussions.microsoft.com> wrote in message
news:0a7701c3df65$34b84b90$a101280a@.phx.gbl...

quote:

---

> Hi,
> I knew the MCDBA contains 3 required exams and 1 elective
> exam.
> 1) Can someone tell me, if I am not go to the training
> classes, just buy books such as MCSE Training Kit:
> Microsoft SQL Server 2000 System Administration, Database
> Design and Implementation, etc. is possible to pass exams?
> 2) Those MCSE Training Kit books contain self-test? If
> they don't contain self-test, where I can find them?
> Thanks,
> Jenny
>

---

|||I agree that the Trancender is the bust resource out there
for passing MCDBA.
The Books are rather scetchy, some are really good, some
are so bad they are not worth the paper they are printed
on. I would sugest you had a look at amazon before buying
them.
The best reference resource however is BOL (which are
suprisingly good.
J

quote:

---

>--Original Message--
>http://www.transcender.com/
>Best self-test stuff out there back when I was taking

---

certification exams

quote:

---

>--
>Kevin Hill, MCSE
>President
>3NF Consulting
>www.3nf-inc.com/NewsGroups.htm
>"Jenny" <anonymous@.discussions.microsoft.com> wrote in

---

message

quote:

---

>news:0a7701c3df65$34b84b90$a101280a@.phx.gbl...
elective[QUOTE]
Database[QUOTE]
exams?[QUOTE]
>
>.
>

---

|||Yes you can pass them without any classroom teaching.
I used a combination of experience (almost 3 years), books (Inside SQL
Server 2000 is excellent), & training videos (cbt nuggets were pretty good).
Cheers,
James Goodman MCSE, MCDBA
http://www.angelfire.com/sports/f1pictures|||Hands on training is the best preparation, period. :-)
Kevin Hill
President
3NF Consulting
www.3nf-inc.com/NewsGroups.htm
"Kevin3NF" <KHill@.NopeIDontNeedNoSPAM3NF-inc.com> wrote in message
news:OCggor23DHA.1428@.TK2MSFTNGP12.phx.gbl...

quote:

---

> http://www.transcender.com/
> Best self-test stuff out there back when I was taking certification exams
> --
> Kevin Hill, MCSE
> President
> 3NF Consulting
> www.3nf-inc.com/NewsGroups.htm
> "Jenny" <anonymous@.discussions.microsoft.com> wrote in message
> news:0a7701c3df65$34b84b90$a101280a@.phx.gbl...
>

---

|||Hi Jenny,
I am not sure how much experience you aquired as a DBA but
I have done some R & D on websites In the process of
preparing for Certification.
To get certified you MUST have MS Press Books and Sybex
Books read & practiced thoroughly ( both includes Test
Simulations also). Apart from the above, there are lot of
sites offering Test Simulation product samples.(some are
downloadable and some are online). practiceing these tests
will make you more comfortable while attempting the Real
Exam. Ensure that you are not going to accept any shortcut
methods of passing the exam. A bit of hardwork and
sincerity , we can pass the exams in flying colors.
Also Look at the article wrote by by Brad M. McGehee.
Self Taught DBA
http://www.sql-server-performance.c..._taught_dba.asp
HTH
Best Wishes
THIRUMAL REDDY MARAM
Sys Admin / SQL Server DBA

quote:

---

>--Original Message--
>Yes you can pass them without any classroom teaching.
>I used a combination of experience (almost 3 years),

---

books (Inside SQL

quote:

---

>Server 2000 is excellent), & training videos (cbt nuggets

---

were pretty good).

quote:

---

>
>--
>Cheers,
>
>James Goodman MCSE, MCDBA
>http://www.angelfire.com/sports/f1pictures
>
>.
>

---

|||I use BOL and and the MOC Press books combined w/ VMWARE and Transcender and
you are good to go.
Steven S. Warren
MCSA, MCSE, MCDBA, CCA, CIW-SA, CIW-MA, NETWORK+, i-NET+
http:\\www.swtechworks.net
"Kevin3NF" <KHill@.NopeIDontNeedNoSPAM3NF-inc.com> wrote in message
news:%23aRknh33DHA.1804@.TK2MSFTNGP12.phx.gbl...

quote:

---

> Hands on training is the best preparation, period. :-)
> --
> Kevin Hill
> President
> 3NF Consulting
> www.3nf-inc.com/NewsGroups.htm
> "Kevin3NF" <KHill@.NopeIDontNeedNoSPAM3NF-inc.com> wrote in message
> news:OCggor23DHA.1428@.TK2MSFTNGP12.phx.gbl...
exams[QUOTE]
>

---

About MCDBA

Hi,
I knew the MCDBA contains 3 required exams and 1 elective
exam.
1) Can someone tell me, if I am not go to the training
classes, just buy books such as MCSE Training Kit:
Microsoft SQL Server 2000 System Administration, Database
Design and Implementation, etc. is possible to pass exams?
2) Those MCSE Training Kit books contain self-test? If
they don't contain self-test, where I can find them?
Thanks,
Jennyhttp://www.transcender.com/
Best self-test stuff out there back when I was taking certification exams
--
Kevin Hill, MCSE
President
3NF Consulting
www.3nf-inc.com/NewsGroups.htm
"Jenny" <anonymous@.discussions.microsoft.com> wrote in message
news:0a7701c3df65$34b84b90$a101280a@.phx.gbl...
> Hi,
> I knew the MCDBA contains 3 required exams and 1 elective
> exam.
> 1) Can someone tell me, if I am not go to the training
> classes, just buy books such as MCSE Training Kit:
> Microsoft SQL Server 2000 System Administration, Database
> Design and Implementation, etc. is possible to pass exams?
> 2) Those MCSE Training Kit books contain self-test? If
> they don't contain self-test, where I can find them?
> Thanks,
> Jenny
>|||I agree that the Trancender is the bust resource out there
for passing MCDBA.
The Books are rather scetchy, some are really good, some
are so bad they are not worth the paper they are printed
on. I would sugest you had a look at amazon before buying
them.
The best reference resource however is BOL (which are
suprisingly good.
J
>--Original Message--
>http://www.transcender.com/
>Best self-test stuff out there back when I was taking
certification exams
>--
>Kevin Hill, MCSE
>President
>3NF Consulting
>www.3nf-inc.com/NewsGroups.htm
>"Jenny" <anonymous@.discussions.microsoft.com> wrote in
message
>news:0a7701c3df65$34b84b90$a101280a@.phx.gbl...
>> Hi,
>> I knew the MCDBA contains 3 required exams and 1
elective
>> exam.
>> 1) Can someone tell me, if I am not go to the training
>> classes, just buy books such as MCSE Training Kit:
>> Microsoft SQL Server 2000 System Administration,
Database
>> Design and Implementation, etc. is possible to pass
exams?
>> 2) Those MCSE Training Kit books contain self-test? If
>> they don't contain self-test, where I can find them?
>> Thanks,
>> Jenny
>
>.
>|||Yes you can pass them without any classroom teaching.
I used a combination of experience (almost 3 years), books (Inside SQL
Server 2000 is excellent), & training videos (cbt nuggets were pretty good).
Cheers,
James Goodman MCSE, MCDBA
http://www.angelfire.com/sports/f1pictures|||Hands on training is the best preparation, period. :-)
--
Kevin Hill
President
3NF Consulting
www.3nf-inc.com/NewsGroups.htm
"Kevin3NF" <KHill@.NopeIDontNeedNoSPAM3NF-inc.com> wrote in message
news:OCggor23DHA.1428@.TK2MSFTNGP12.phx.gbl...
> http://www.transcender.com/
> Best self-test stuff out there back when I was taking certification exams
> --
> Kevin Hill, MCSE
> President
> 3NF Consulting
> www.3nf-inc.com/NewsGroups.htm
> "Jenny" <anonymous@.discussions.microsoft.com> wrote in message
> news:0a7701c3df65$34b84b90$a101280a@.phx.gbl...
> > Hi,
> >
> > I knew the MCDBA contains 3 required exams and 1 elective
> > exam.
> >
> > 1) Can someone tell me, if I am not go to the training
> > classes, just buy books such as MCSE Training Kit:
> > Microsoft SQL Server 2000 System Administration, Database
> > Design and Implementation, etc. is possible to pass exams?
> >
> > 2) Those MCSE Training Kit books contain self-test? If
> > they don't contain self-test, where I can find them?
> >
> > Thanks,
> > Jenny
> >
>|||Hi Jenny,
I am not sure how much experience you aquired as a DBA but
I have done some R & D on websites In the process of
preparing for Certification.
To get certified you MUST have MS Press Books and Sybex
Books read & practiced thoroughly ( both includes Test
Simulations also). Apart from the above, there are lot of
sites offering Test Simulation product samples.(some are
downloadable and some are online). practiceing these tests
will make you more comfortable while attempting the Real
Exam. Ensure that you are not going to accept any shortcut
methods of passing the exam. A bit of hardwork and
sincerity , we can pass the exams in flying colors.
Also Look at the article wrote by by Brad M. McGehee.
Self Taught DBA
http://www.sql-server-performance.com/self_taught_dba.asp
HTH
Best Wishes
THIRUMAL REDDY MARAM
Sys Admin / SQL Server DBA
>--Original Message--
>Yes you can pass them without any classroom teaching.
>I used a combination of experience (almost 3 years),
books (Inside SQL
>Server 2000 is excellent), & training videos (cbt nuggets
were pretty good).
>
>--
>Cheers,
>
>James Goodman MCSE, MCDBA
>http://www.angelfire.com/sports/f1pictures
>
>.
>|||I use BOL and and the MOC Press books combined w/ VMWARE and Transcender and
you are good to go.
--
Steven S. Warren
MCSA, MCSE, MCDBA, CCA, CIW-SA, CIW-MA, NETWORK+, i-NET+
http:\\www.swtechworks.net
"Kevin3NF" <KHill@.NopeIDontNeedNoSPAM3NF-inc.com> wrote in message
news:%23aRknh33DHA.1804@.TK2MSFTNGP12.phx.gbl...
> Hands on training is the best preparation, period. :-)
> --
> Kevin Hill
> President
> 3NF Consulting
> www.3nf-inc.com/NewsGroups.htm
> "Kevin3NF" <KHill@.NopeIDontNeedNoSPAM3NF-inc.com> wrote in message
> news:OCggor23DHA.1428@.TK2MSFTNGP12.phx.gbl...
> > http://www.transcender.com/
> >
> > Best self-test stuff out there back when I was taking certification
exams
> >
> > --
> > Kevin Hill, MCSE
> > President
> > 3NF Consulting
> >
> > www.3nf-inc.com/NewsGroups.htm
> >
> > "Jenny" <anonymous@.discussions.microsoft.com> wrote in message
> > news:0a7701c3df65$34b84b90$a101280a@.phx.gbl...
> > > Hi,
> > >
> > > I knew the MCDBA contains 3 required exams and 1 elective
> > > exam.
> > >
> > > 1) Can someone tell me, if I am not go to the training
> > > classes, just buy books such as MCSE Training Kit:
> > > Microsoft SQL Server 2000 System Administration, Database
> > > Design and Implementation, etc. is possible to pass exams?
> > >
> > > 2) Those MCSE Training Kit books contain self-test? If
> > > they don't contain self-test, where I can find them?
> > >
> > > Thanks,
> > > Jenny
> > >
> >
> >
>

About building international applications in dotnet

Hi,

I am developing an application using C#.NET that accesses a remote database that that contains japanese characters.

My sample querry is strCommand = "SELECT * FROM table WHERE prodname = 'ＣＲ新海物語スペシャルＭ８'";

The result of querry displayed in the binded datagrid also contains other rows that has this prodname:

ＣＲＦ湯けむり紀行ＳＦ－Ｔ
ＣＲぱちんこハイサイＶＲ１
ＣＲホワイトエンジェルＦＳ

etc.

Thanks in advance for your help.

You forgot to ask a question.
|||

Hi,

I am developing an application using C#.NET that accesses a remote database that that contains japanese characters.

My sample querry is strCommand = "SELECT * FROM table WHERE prodname = 'ＣＲ新海物語スペシャルＭ８'";

The result of the querry above that is displayed in the binded datagrid also contains other rows that has this prodname:

ＣＲＦ湯けむり紀行ＳＦ－Ｔ
ＣＲぱちんこハイサイＶＲ１
ＣＲホワイトエンジェルＦＳ

etc.

Why does the command yields other records where the prodname field contains the 'CR' thing?

Sample querry result in a datagrid:

field1 field2 field3 prodname

a as er ＣＲ新海物語スペシャルＭ８

w aa ww ＣＲＦ湯けむり紀行ＳＦ－Ｔ

ss dd ee ＣＲぱちんこハイサイＶＲ1

sdds ddd ee ＣＲ新海物語スペシャルＭ８

rf d5r wwe ＣＲぱちんこハイサイＶＲ１

Does this strange and redundant output has something to do with the Japanese characters contained in some fields

of the table?

Thanks in advance for your help.

|||Try with the correct nvarchar syntax:

SELECT * FROM table WHERE prodname = N'ＣＲ新海物語スペシャルＭ８'