Products
What's New
Demos
Free Online Evaluation
Platform Support Matrix
Compare Editions
Editions
SplendidCRM Enterprise
SplendidCRM Professional
SplendidCRM Community
Open Source
Download Community Edition
SplendidCRM & SugarCRM Public Licenses
GNU Affero General Public License
Forums
Partners
Becoming a Partner
Training
Company
Management Team
Press Releases
December 16, 2011
December 15, 2010
December 8, 2010
April 14, 2010
October 20, 2009
December 16, 2008
December 1, 2008
October 8, 2008
June 2, 2008
April 27, 2007
March 16, 2007
August 15, 2006
January 24, 2006
December 07, 2005
News Archive
Contact Us
Blog
Store
Thursday, February 09, 2012
..::
Forums
::..
Register
Login
Forums
Search
Forum Home
Forum
Mainstream Foru...
Language Packs ...
SQL query failed when dealing with UTF-8 characters
Previous
Next
4/5/2009 11:07 PM
Amico Boon
Joined: 4/5/2009
Posts: 1
SQL query failed when dealing with UTF-8 characters
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
4/6/2009 1:56 AM
Support
Joined: 1/3/2006
Posts: 3260
Re: SQL query failed when dealing with UTF-8 characters
Thanks. I believe that we fixed this issue last year.
What version of SplendidCRM are you running?
Page 1 of 1
Previous
Next
Forum
Mainstream Foru...
Language Packs ...
SQL query failed when dealing with UTF-8 characters
Copyright (c) 2006-2010 SplendidCRM Software, Inc. All Rights Reserved.
Terms Of Use
Privacy Statement
DotNetNuke® is copyright 2002-2012 by DotNetNuke Corporation