I need to be able to put special characters in my category titles. Specifically, I want to put in TM for Tradmark.
When I put in the html for TM, it just writes the html in there and doesn’t convert it to the TM symbol.
Does anyone have an idea of how I can fix this?
Thanks,
Brandon
Alt 0153
[quote name=‘brandonvd’]I need to be able to put special characters in my category titles. Specifically, I want to put in TM for Tradmark.
When I put in the html for TM, it just writes the html in there and doesn’t convert it to the TM symbol.
Does anyone have an idea of how I can fix this?
Thanks,
Brandon[/quote]
[quote name=‘The Tool’]Alt 0153[/quote]
For anyone else attempting this, be aware that your trademarks/registration symbols will not transfer to datafeeds. In most cases datafeeds are denied due to non- ASCII characters being used.
Do I need to put that in a special way or something? When I just type that into the Name section of the category, it just writes it out like I type it.
I’ve also tried:
™
and
&0153;
But those just get written out like I type them as well.
Thanks again,
Brandon
Press Alt while typing 0153
[url]http://demo.cs-cart.com/professional/admin.php?dispatch=categories.update&category_id=168[/url]
[url]Instant Demo - CS-Cart Multi-Vendor Demo Try Free for 15 days
In response to JLS’s post, yes, anytime you import/export it will change from ™ to â„¢. I have noticed with both Bing and Google that it is still recognized as ™.
Dude, that is awesome. I can’t believe something that simple works so well. I thought for sure that I was going to have to hire TonyB or something to edit some files to make this work.
You totally made my day. Thank you very much.
Brandon
No problem. It was an easy enough question. 
[quote name=‘The Tool’]Press Alt while typing 0153
[url]http://demo.cs-cart.com/professional/admin.php?dispatch=categories.update&category_id=168[/url]
[url]Instant Demo - CS-Cart Multi-Vendor Demo Try Free for 15 days
Thanks for the link dude.
Should be refreshed by now but obviously brandon was able to view it.
what about when the special characters are shown after an update script is ran? Let me explain myself better.
I have a script made to measure for my store so that I can update it automatically thru a scripts that takes the content from a supplier csv url and “translate them” for cs-cart so it can be imported.
The script and the automatic import were working very well with a cron until recently when the supplier changed the csv url. Apparently the csv itself has not change, same content, same colummns, when you open it manually you can see all descriptions and titles well written in Spanish, BUT, there's always a but, when the script is run, all the content imported into the site gets full of weird strange characters, very hadr to read and annoying.
How can I solution that? is there any code I need to add in the script in order to make the content get imported as it should?
Please, let me know, it's really a headache. The supplier keeps telling me nothing has changed except for the url and more content than before, I'm rather lost at this.
Thank you all that can shed some light in this issue, thank you in advance.
Mirna, If nothing has changed with the file, it sounds like something on your server has changed. Do you know if any changes to the server have been made? (i.e. updates, change server) You may need to ask your host.
If you go into phpMyAdmin, on the main screen you should see a setting called “MySQL connection collation”. For english this setting is “utf8_general_ci”. Since I am not familiar with your language, I am guessing that yours should be either “utf8_spanish_ci” or “utf8_spanish2_ci”.
If you go into the tables, will see the encoding/collation of the table next to it.
Thanks for your reply, I'll check that and report.
I found this article in ehow that might be also useful, what do you think?
How to save csv in utf-8
That just shows you how to save it in Notepad or Excel. Can you PM me the file or the link to the file?
[quote name='The Tool' timestamp='1318458487' post='123573']
If you go into phpMyAdmin, on the main screen you should see a setting called “MySQL connection collation”. For english this setting is “utf8_general_ci”. Since I am not familiar with your language, I am guessing that yours should be either “utf8_spanish_ci” or “utf8_spanish2_ci”.
If you go into the tables, will see the encoding/collation of the table next to it.
[/quote]
yes, I did it and I have for most tables “utf8_general_ci” and for a few others, oh my God, I have “latin1_swedish_ci” Swedish!!! How did that happen?
Summing up, I do not have in any utf8_spanish_ci, which I suppose it's the problem, my store is solely in Spanish.
I'm sorry to ask again for orientation: how do I change all tables to the proper setting? I know very little about mysql, and I do know one must be extremely careful when dealing with it.
I can't wait for your reply , thanks for the help, I hope this is useful for so many other non-English cs-cart users
note: just sent you a PM with the link to the file
In case it helps I have this info in “Variables”:
character set client utf8
(Valor global) latin1
character set connection utf8
(Valor global) latin1
character set database latin1
character set filesystem binary
character set results utf8
(Valor global) latin1
character set server latin1
character set system utf8
character sets dir /usr/share/mysql/charsets/
collation connection utf8_unicode_ci
(Valor global) latin1_swedish_ci
collation database latin1_swedish_ci
collation server latin1_swedish_ci