No data return If search condition of a select query on a nVarChar column contains only numerals

Question

5.00/5 (1 vote)

See more:

I have windows application to synchronize Sql CE database data of a windows mobile application. I got few issues on synchronization of mobile connected to windows 7 32bit PC.

On synchronization, windows application will copy Sql CE databse from Mobile Device to the PC and do synchronization of data with locally coppied database then copy back to the Mobile Device. If the PC which done synchronization is a windows 7 32Bit then I'll get following issues in Windows Mobile Application when working with synchronized database.

If there is a table with nVarChar column and do search query on that column, No data will return if search condition contain numerals with single quotes to indicate value as a string (In following example strProductID is a nVarchar column)

eg:-

SQL

SELECT * FROM Products WHERE strProductID='2345'

But numerals without quotes or alpha with quotes will works fine

eg:-

SQL

SELECT * FROM Products WHERE strProductID=2345

or

SQL

SELECT * FROM Products WHERE strProductID='asdasd'

Posted 16-Apr-13 20:38pm

milinda saranga

Updated 16-Apr-13 21:46pm

v6

Add a Solution

1 solution

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

Aarti Meswania · Answer 1 · 2013-04-16T21:17:00

Solution 1

Try this

SQL

SELECT * FROM Products WHERE strProductID = N'2345'

Happy Coding!
:)

Posted 16-Apr-13 21:17pm

Aarti Meswania

Comments

milinda saranga 17-Apr-13 3:38am

I have a mobile application which already diployed and it works fine on synchronization of mobile connected with XP or Windows 7 64bit PC but only with Windows 7 32bit i will get this issue. I need to find is there any solution without doing changes to application code such as changing configurations of the windows environment wich done synchronization or any such solution.