Last post Jul 19, 2011 09:21 AM by juhi_it
Jul 14, 2011 02:02 AM|juhi_it|LINK
Can any body suggest me how to fatch gujarati data from database using like cause.
i wrote query like this:
Select RId,ItemName from TblRowMaterialItemMaster where ItemName like '@%ડાલડા%'
but it could not find any result.
Please suggest me query.
Thanks in Advance.
Jul 14, 2011 02:32 AM|bhavik.y.shah|LINK
Which Database you are using and under which data type you are storing data it is unicode or nvarchar.
Generally it SQL treates data as string and we need to identify it as a Unicode i guess from that we can achieve your task.
I found two links please go thru that and let us know whats the result.
Jul 14, 2011 02:36 AM|juhi_it|LINK
I m working on Windows application so i m using MS Access2007 because it not suitable to use SQL server for win application.
and datatype of field is "TEXT".
Jul 14, 2011 02:44 AM|bhavik.y.shah|LINK
You are using MS Access ok.
So need to check that which datatype is suitable for that.
Then also please try provided links and let me know what you got.
Jul 14, 2011 04:59 AM|juhi_it|LINK
i got solution ...
Jul 16, 2011 03:19 AM|Damon Liu - MSFT|LINK
could you please display your solution in the forum and mark as answer.
This will make answer searching in the forum easier and be beneficial to other community members as well.
Thank you for your understanding.
I would do appreciate your share and time!
Jul 19, 2011 09:21 AM|juhi_it|LINK
write query like this:
Select * from TblRowMaterialItemMaster where IsActive=true and ItemName like '*પનીર*'