This content has been marked as final. Show 6 replies
Do you have the European version of the Verity Locales language pack installed?
My providere added the french locale and all the european ones too, previously I could not create a french collection.
I have found the trouble, my collection are wit the charset 1252, but I sould be using ISO-8859-1but Im not sure how to change the charset when I create a verity collection. I can change the language but I haven't seen how I can change its charset
Just a quick idea:
Attempt to change the collation upon reading data from database, something like:
SELECT myText COLLATE charset 1252
or try fumbling with the following option for your DB in CF-Administrator:
-- Enable Unicode for data sources configured for non-Latin characters
never used it though.
The problem is only with verity collection when I index the data. It works fine when juste posting the info with cfquery. I did check my database (mysql) and it is set for the right charset already.
I did try with the collate thing and it wont work
I folowed this link http://www.adobe.com/cfusion/knowledgebase/index.cfm?id=tn_18163
and I did try to go in the style.uni and change all the charset form 1252 to 8859 then reindex the collection but it did not work. I tried diferent language for the create collection but still no luck.
I still cant find a way to change the charset for my collection. My datasource has the right charset since with a cfsearch I get what I want, but it is not a very efective way to search.