ok fixed that one. <cfquery name="testLang" datasource="#dsn#"> select hungarian from languages where hungarian like <cfqueryparam cfsqltype="cf_sql_varchar" value="%találtunk megfelelõ%"> </cfquery>
On 10/5/05, Duncan <[EMAIL PROTECTED]> wrote: > > ok so I now have the <cfqueryparam wrapped around the var in the insert. > It displays fine, but I dont seem to be able to match the text with a query > like this: > > select id,hungarian from languages where hungarian like '%megfelelõ%' > > Whats the deal there? > > On 10/5/05, Duncan <[EMAIL PROTECTED]> wrote: > > > > Thanks Paul. The cfsqlparam thing seems to have done the trick. > > > > On the collation end, we are looking over 18 languages, I think thats > > pretty much any character under the sun. We have a db table, one column for > > each language, so I am thinking I take Andy's suggestion and make the > > collation on each individual column fit the language, rather than simply > > making them UTF-8. Would this be a more effective use of SQL memory? > > > > > > On 10/5/05, Paul Hastings <[EMAIL PROTECTED] > wrote: > > > > > > Duncan wrote: > > > > The only way we can get the chars to display correctly is by > > > entering them > > > > in to SQL Server 2000 using th N'string in here' notation. But that > > > means > > > > > > no, you could & should use cfqueryparam along with turning on the > > > unicode option for that DSN. here's a blog entry on the subject: > > > http://www.sustainablegis.com/blog/cfg11n/index.cfm?mode=entry&entry=F9553D86-20ED-7DEE-2A913AFD8651643F > > > > > > > > > > > > > the db collation is SQL_Latin_General at the moment - I have a bad > > > feeling > > > > this is the problem and its not easy to change? > > > > > > that would depend on if the chars you're looking for are in that code > > > page. even w/unicode, you want to use collations that cover the > > > majority > > > of your user's languages. > > > > > > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:220095 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
