Home
What's New
Demos
Free Trial
Products
SplendidCRM Enterprise
SplendidCRM Professional
SplendidCRM Full Featured
SplendidCRM Community
SplendidCRM Plug-in for Outlook 2003/2007
Platform Support Matrix
Compare Editions
Documents
SplendidCRM & SugarCRM Public Licenses
SplendidCRM Source Code License Agreement
eWeek Podcast Transcript - June 11, 2007
Case Study - Promero
Case Study - CBT Nuggets
Load test Summary - 4000 users in 30 minutes
Downloads
Store
Partners
Becoming a Partner
Training
Forums
Blog
About Us
Contact Us
Press Releases
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
Directories
Thursday, September 09, 2010
..::
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 10: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 12:56 AM
Support
Joined: 1/3/2006
Posts: 2866
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-2010 by DotNetNuke Corporation