torbenus
Posts: 4
|
| Posted: 03/25/2009, 4:43 AM |
|
I having 2 problems :
1. The autocompletelist dosn't show danish spec. characters.
2. The autofill function won't autofill a result with danish spec. characters.
Both functions work fine if no spec. characters are used.
Any Ideas ?
Best regards
Torben Søemod (Torben Soemod - for the international)
|
 |
 |
joejac
Posts: 242
|
| Posted: 03/26/2009, 1:28 PM |
|
Hello torbenus,
Have you tried this?:
Project Settings
Locales & Encodings
File Encoding: Unicode (UTF-8)
Default HTML Encoding: Unicode (UTF-8)
Best regards
joejac
|
|
|
|
torbenus
Posts: 4
|
| Posted: 03/27/2009, 6:22 PM |
|
I have tried difrent codec solution incl. utf-8 (And just tried once more to sure)
But the only thing that works is if i remove the special charecters from the result - then i works fine 
Any other ideas, since im blank ?
Best regards
Torben
|
|
|
|
itmanvn
Posts: 12
|
| Posted: 05/30/2009, 9:09 AM |
|
I have the same problem with unicode characters, tried to use Prototype and Yahoo UI, no luck.
It's only work if there aren't any unicode characters.
Could anyone can help?
|
|
|
|
jjrjr1
Posts: 942
|
| Posted: 05/30/2009, 9:18 AM |
|
Hi
I had a similar problem with Spanish and French Characters.
Have you looked at the encoding in your MySql database table.
Just a thought
_________________
John Real - More CodeCharge Studio Support at - http://CCSElite.com |
|
|
|
jjrjr1
Posts: 942
|
| Posted: 05/30/2009, 9:34 AM |
|
Hi Again
I just looked up the project I solved this type of problem in
It was for this multi-language site.
http://realtest.biz/TAXIFEE
Notice in the dropdown language selection menu. The special language characters do display properly.
Here were my settings I used to make this work:
MySql colation for your table should be utf8_general_ci or utf8_general_CS , depending on your case sesnitivity requirements.
In the CCS Project for locales + Settings the file encoding is set to Western European (Windows-1252)
In the properties data for the project Charset is set to Windows-1252 and Output File set to Windows.
These settings were able to deal with the special characters. There night be other combos that will also. But after messing with it for a long time I found this works fine.
Let me know if that helps.
John
_________________
John Real - More CodeCharge Studio Support at - http://CCSElite.com |
|
|
|
jjrjr1
Posts: 942
|
| Posted: 05/30/2009, 9:37 AM |
|
BTW. Don't forget to republish the entire project after making those changes
You might get CCS warnings since you already published with other settings. CCS has problems here
What you might need to do is create a new page wirh the changed settings and manually copy the new charsetv meta tags in all pages that might give warnng messages.
_________________
John Real - More CodeCharge Studio Support at - http://CCSElite.com |
|
|
|
jjrjr1
Posts: 942
|
| Posted: 05/30/2009, 9:48 AM |
|
OH.. I forgot...
One more setting needs to be put in the project data properties box.
Set the Encode Extensions to iConv
It won't work without that set.
John
_________________
John Real - More CodeCharge Studio Support at - http://CCSElite.com |
|
|
|
itmanvn
Posts: 12
|
| Posted: 05/30/2009, 9:56 AM |
|
Hi all,
Found solution!!!  just open the .html file and change the escape() function to encodeURI()
This is my working (ff3, ie7) source code.
APACHE2, PHP5, ORACLE 10G
//PTAutoFill1 Loading @22-291E7059
function CUSTOMERSFULLNAMEPTAutoFill1_start(sender) {
new Ajax.Request("services/tnkn_CUSTOMERS_FULLNAME_PTAutoFill1.php?keyword=" + encodeURI($("CUSTOMERSFULLNAME").value), {
method: "get",
requestHeaders: ['If-Modified-Since', new Date(0)],
onSuccess: function(transport) {
var valuesRow = eval(transport.responseText)[0];
getSameLevelCtl("CUSTOMERSADDRESS", sender).value = valuesRow["ADDRESS"];
getSameLevelCtl("CUSTOMERSPHONE", sender).value = valuesRow["PHONE"];
getSameLevelCtl("CUSTOMERSMOBILE", sender).value = valuesRow["MOBILE"];
getSameLevelCtl("CUSTOMERSEMAIL", sender).value = valuesRow["EMAIL"];
getSameLevelCtl("CUSTOMERSNOTES", sender).value = valuesRow["NOTES"];
getSameLevelCtl("CUSTOMERSCREATE_DATE", sender).value = valuesRow["CREATE_DATE"];
getSameLevelCtl("CUSTOMERSUSER_ID", sender).value = valuesRow["USER_ID"];
},
onFailure: function(transport) {
alert(transport.responseText);
}
});
}
//End PTAutoFill1 Loading
|
|
|
|
jjrjr1
Posts: 942
|
| Posted: 05/30/2009, 10:02 AM |
|
Hi
That is excellent info.
Is this modifying CCS standard code or is it custom code area???
It is possible thet the properties for encoeding = iConv does this.
It is not advisable to change CCS standard code as it will break the IDE and it will no longer be maintainable.
We should check is that project property causes CCS Ajax to properly do that..
If not Yes should be made aware of this problem.
Let us know.
John
_________________
John Real - More CodeCharge Studio Support at - http://CCSElite.com |
|
|
|
itmanvn
Posts: 12
|
| Posted: 05/30/2009, 10:16 AM |
|
Hi jjrjr1,
This is my first time with CCS, I want to use autocomplete and autofill, CCS standard code use escape() function which is not recommended when encoding an URI. And I think this is a BUG of CCS.
Quote :The escape() and unescape() functions should not be used to encode or decode URIs. Use encodeURI() and decodeURI() functions instead!
iConv does not effect this problem.
Anyway, thanks for great apps 
|
|
|
|
jjrjr1
Posts: 942
|
| Posted: 05/31/2009, 3:07 AM |
|
Hi
I think you are right this sounds like a bug.
You should probably submit a support request with Yessoftware giving them the details of this bug.
Hopefully they will fix it very soon.
John
_________________
John Real - More CodeCharge Studio Support at - http://CCSElite.com |
|
|
|
peterr
Posts: 5971
|
| Posted: 06/01/2009, 6:13 PM |
|
Hi,
This doesn't look like a bug. Everything works fine if you specify correct Charset in Project Settings -> Server/Script.
_________________
Peter R.
YesSoftware Forums Moderator
For product support please visit http://support.yessoftware.com |
|
|
|
jjrjr1
Posts: 942
|
| Posted: 06/01/2009, 7:48 PM |
|
I suggested that Peter. (But told him to set if from the project properties box)
He said that made no difference??
Also what about iConv setting or mb. Does not one of those have to be set for this type and multi-byte support to work??
I Might be confused on these settings
John
_________________
John Real - More CodeCharge Studio Support at - http://CCSElite.com |
|
|
|
peterr
Posts: 5971
|
| Posted: 06/01/2009, 8:12 PM |
|
John,
I am not sure about all the details, but we simply tested this and worked fine.
_________________
Peter R.
YesSoftware Forums Moderator
For product support please visit http://support.yessoftware.com |
|
|
|
Oper
Posts: 1195
|
| Posted: 06/02/2009, 5:03 AM |
|
Its working fine for me also, like 90% of our APP use Spanish (áíóé).
if you have isue with this is just Charset setup.
* Database
* HTML Charset
* Code Charset
Doble check and you will get the right solution.
i will avoid the modify of the CCS Generated code. (this kind of function may have lot of modification in the future and will get you in trouble in next versions......... [maybe] <--)
_________________
____________________________
http://www.7bz.com (Free CMS,CRM Developed in CCS)
http://www.PremiumWebTemplate.com
Affiliation Web Site Templates
Please do backup first |
|
|
|
itmanvn
Posts: 12
|
| Posted: 06/03/2009, 5:33 AM |
|
Cool!!! happy that I'm wrong
|
|
|
|
itmanvn
Posts: 12
|
| Posted: 06/03/2009, 5:33 AM |
|
srr, double post
|
|
|
|
alfonso
Posts: 121
|
| Posted: 07/02/2009, 3:42 AM |
|
Hi guys!
I´ve the same problem with á é í ó ú ñ (spanish characters), but i didn´t find the function in the .html, i have this
//Initialize fotoss_comentariofotoPTAutocomplete1 @14-B4D5FF44
function
fotoss_comentariofotoPTAutocomplete1_start()
{
if ($("fotoss_comentariofoto"))
new Ajax.Autocompleter("fotoss_comentariofoto", "fotoss_comentariofoto_choices",
"services/inicio_fotos_s_comentariofoto_PTAutocomplete1.php", {});
} //End Initialize fotoss_comentariofotoPTAutocomplete1
what i can do for fix this problem?? thanks
|
|
|
|
kcedit
Posts: 20
|
| Posted: 08/11/2009, 4:12 PM |
|
I have very similar problem with dependent listbox which uses Prototype.
Dependent listbox shows Sos& # 250;a (I inserted space between '&' and '#' to make it show up here) instead of Sosúa. Regular listbox in the same page shows correctly.
Using Firebug, I could see the Prototype is converting "Sosúa" (as in the DB) to Sos& # 250;a.
JSON shows up like below:
[
[ "42404", "Cabarete" ] ,[ "6399", "Puerto Plata" ] ,[ "14808", "Sos& # 250;a" ]
]
Dependent listbox is not able to display Sosúa.
|
|
|
|
kcedit
Posts: 20
|
| Posted: 08/12/2009, 8:47 AM |
|
I found a solution to the problem above.
I had to change the following code
onSuccess: function(transport)
{ var valueRows = eval(transport.responseText);
to
onSuccess: function(transport)
{ var valueRows = eval(transport.responseText.unescapeHTML());
Prototype unescapeHTML function decoded the HTML coded string.
|
|
|
|
Oper
Posts: 1195
|
| Posted: 08/17/2009, 7:20 PM |
|
kcedit,
that will work for sure, what you should be worry with that solution if, just if some change on
Codecharge new version, this part of your program will be Out.
also: no sabia que sosúa lleva Acento. o lo colocaste solo para prueba?
nunca lo he utilizado con acento.
_________________
____________________________
http://www.7bz.com (Free CMS,CRM Developed in CCS)
http://www.PremiumWebTemplate.com
Affiliation Web Site Templates
Please do backup first |
|
|
|
kcedit
Posts: 20
|
| Posted: 08/18/2009, 8:04 PM |
|
Oper,
unfortunately... yes, it could be a problem with future upgrade. I kept a copy of old code in another file. I have to reconcile this if Codecharge changes anything in the future. But I think it is a bug. yes should fix this. I have to open a ticket.
I had to use Google translator to figure out your second question. I did not pick Sosua. One of the visitors pointed out about Sosua. Then I found all other accented city names are showing up incorrectly. I used a 3rd party database for country, region, city/town names. That came with a lot of accented names. There are is so many, I cannot fix easily now. In my to-dos for now... may be I have to do global search & replace.
|
|
|
|
