Passsing Unicode String in SQL Query in VC++ 6.0

Question

0.00/5 (No votes)

See more:

Hi Experts,

I have written one program which handles some Tables containing Unicode Values.
I want to search those values by passing a Unicode Value.

What should I DO??
I have write following code, which seems to be right, but could not return any records.

Can you help..Its urgent..
I tried out various ways but dont work..

int Get_Match_Vocables(unsigned short *usFindVoc,CRecordset &amp;amp;recOut)
{
	
	CDatabase cn;
	CString FieldValue1,FieldValue2,FieldValue3;
	CDBVariant varvalue;
	CString sqlStr;

	CString csPwd,csUser,csServer,csDBName;
	csPwd = "SQLServer2005";
	csUser = "sa";
	csDBName = "DeccanCollege";
	csServer = "DECCANSERVER";

	cn.OpenEx(_T("DRIVER={SQL Server};Pwd="+csPwd+";Uid="+csUser +";Database="+csDBName+";Server="+csServer),CDatabase::noOdbcDialog);
	CRecordset rec(&amp;amp;cn);

	sqlStr = "Select * from Vocablemaster where slvid in(Select slvid from slipvocmaster where binno between 165 and 169) and (VocDescSan like N'%"+CString(usFindVoc)+"%')";
	
	rec.Open( CRecordset::forwardOnly,sqlStr,CRecordset::none);

       while(!rec.IsEOF())
	{
		rec.GetFieldValue((short)0,FieldValue1);
		rec.GetFieldValue((short)1,FieldValue2);
		rec.GetFieldValue((short)2,FieldValue3); 
		rec.MoveNext();
	}
return (int)rec.GetRecordCount() ;
}

In above code, usFindVoc is Unicode value, passed to this function.
When I checked its HEX value, it is correct which I have sent to it.

Please help .. if any mistakes then please suggest the corrections..
Thanks...

.....Victory...........

Posted 23-Jun-10 4:25am

vijay.victory

Updated 23-Jun-10 4:52am

LittleYellowBird

v3

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)

Single Step Debugger · Answer 1 · 2010-06-23T06:06:00

Solution 1

Why you are not using _T("<your character="">") and LPCTSTR instead of unsigned short for Unicode character in the funcion arguments?

Posted 23-Jun-10 6:06am

Single Step Debugger

Comments

vijay.victory 24-Jun-10 6:29am

Thnks for your suggestion..ButI already tried it out.
Actualy this code is in DLL and I m going to pass the Unicode parameter to this function from Delphi.
SO i have to pass it as PWORD i.e. Unsigned Short in VC.

Any Another suggestions???
Please.......

-------------------
Victory