Forums

 
ForumForumMainstream Foru...Mainstream Foru...Language Packs ...Language Packs ...SQL query failed when dealing with UTF-8 charactersSQL query failed when dealing with UTF-8 characters
Previous Previous
 
Next Next
New Post
 4/5/2009 10:07 PM
 
 Modified By Amico Boon  on 4/5/2009 10:07:35 PM
Hi, Environment: Windows XP+MS SQL Express2005+ASP.NET 2.0+Visual Studio 2005 SplendidCRM_3.0.3259.3335_Community Simplified Chinese(UTF-8) Action:use search engine in Leads,Contacts, Accounts etc. Problem:search english phrases is ok, but search Chinese will be failed(return no records) Probably Reason: SQL query in UTF-8 should add an "N" before the querying phrase. for example: select * from tbl_flash where flashname like N'%超市购物%'. Solution:modify the BuildQuery() function in _code\SearchBuilder.cs My Question:How to modify the BuildQuery function? Thanks! Contact Me: amicob@sagewisea.com
New Post
 4/6/2009 12:56 AM
 

Thanks.  I believe that we fixed this issue last year.

What version of SplendidCRM are you running?

 

Previous Previous
 
Next Next
ForumForumMainstream Foru...Mainstream Foru...Language Packs ...Language Packs ...SQL query failed when dealing with UTF-8 charactersSQL query failed when dealing with UTF-8 characters