XOOPS 
Forum
Forum Index General Forums Community Support Modules Support Themes Support Development International Support Module Hack Reviews Theme Designer Talk
  1. Board index / 
  2. XOOPS Modules Support forums / 
  3. Module usage questions 
  4.  / SmartSection and UTF-8, category name
Register
1
alien-shot
SmartSection and UTF-8, category name

  • 2009/12/1 17:08

  • alien-shot

  • Just popping in

  • Posts: 42

  • Since: 2009/8/21


Good day! I am from Russia! Please help me with module SmartSection.
Im using utf-8 encoding! The maximum length of name for the category of 100 characters! It is possible to increase this value?
2
ghia
Re: SmartSection and UTF-8, category name

  • 2009/12/1 18:35

  • ghia

  • Community Support Member

  • Posts: 4953

  • Since: 2008/7/3 1


If you have phpMyAdmin, then you could change the column type from varchar(100) to varchar(255) for field 'name' of table 'xoops_smartsection_categories'.
3
alien-shot
Re: SmartSection and UTF-8, category name

  • 2009/12/1 19:21

  • alien-shot

  • Just popping in

  • Posts: 42

  • Since: 2009/8/21


I already did, but it has not brought any results!The problem remains!
4
alien-shot
Re: SmartSection and UTF-8, category name

  • 2009/12/1 23:05

  • alien-shot

  • Just popping in

  • Posts: 42

  • Since: 2009/8/21


Dear forum users, I decided my problem! For those who use the Russian text and utf-8 to name length category was more necessary to correct the file / smartsection / class / category.php line 50. Value change for 255! Then correct the SQL / smartsection / sql / mysql.sql `name` varchar (100) NOT NULL default'', to `name` varchar (255) NOT NULL default'', And all you have to work! Everyone thank you very much for your attention)
5
chefry
Re: SmartSection and UTF-8, category name

  • 2010/6/2 9:46

  • chefry

  • Home away from home

  • Posts: 1005

  • Since: 2006/10/14


Speaking of UTF-8, Smartsection 2.14 (Final) on Xoops 2.4.4 does not show UTF-8 characters in the title. It also won't show commas, apostrophies, etc .

For example, instead of &, it shows & amp ;

Does anyone know a fix for this?

The body of the text is ok, it's just in the title that it's screwed up
6
Peekay
Re: SmartSection and UTF-8, category name

  • 2010/6/2 15:01

  • Peekay

  • XOOPS is my life!

  • Posts: 2335

  • Since: 2004/11/20


If quotes are safely htmlencoded in the DB, you could try something like:

$title = $myts->undoHtmlSpecialChars($article->getVar('title'));


Please note, this is not Smartsection code. You will have to find the appropriate variable to mess with.
A thread is for life. Not just for Christmas.
7
chefry
Re: SmartSection and UTF-8, category name

  • 2010/6/4 14:04

  • chefry

  • Home away from home

  • Posts: 1005

  • Since: 2006/10/14


I'm starting to think this is a Xoops problem, and not a Smartsection problem

as an example

In the edit screen of the file, and in the database the name appears as Hamersley's, which is correct

but in the index of that subcat is shows Hamersley's

and it's doing it for everything
i.e. Eggs "arriminate"
Sander's Restaurant Hot Fudge


Wait..... this wouldn't be a problem with the theme would it?
8
Peekay
Re: SmartSection and UTF-8, category name

  • 2010/6/4 23:11

  • Peekay

  • XOOPS is my life!

  • Posts: 2335

  • Since: 2004/11/20


I would imagine this is likely to be a MySQL compatibility problem. Xoops character set is UTF-8 since Xoops 2.3 and this can cause issues with some older modules. I have had to employ the above hack in an older module I am working on because the DB charset is Latin1. You can store UTF-8 in L1, but the input and output gets messy. Or, it could just be that the old module doesn't do UTF-8.

You can change the Xoops charset, or if you use Xoops 2.0.18 it will probably work fine.

But of course... I am not allowed to suggest that
A thread is for life. Not just for Christmas.
9
ghia
Re: SmartSection and UTF-8, category name

  • 2010/6/5 3:11

  • ghia

  • Community Support Member

  • Posts: 4953

  • Since: 2008/7/3 1


In 2.4.4, there where some changes in handling data to and from the database, in order to correct the code window problem.
Check on a local server if the problem still exists in 2.4.5rc2.
10
chefry
Re: SmartSection and UTF-8, category name

  • 2010/6/5 11:34

  • chefry

  • Home away from home

  • Posts: 1005

  • Since: 2006/10/14


What's 2.4.5rc2. ?

the next Xoops download?

I think I'll wait until it's not a release candidate
(1) 2 »

Login

Register now!  |  Lost Password?

Search

Advanced Search

Recent Posts

Who's Online

351 user(s) are online (258 user(s) are browsing Support Forums)

Members: 0

Guests: 351

more...

Donat-O-Meter

Stats
Goal: $100.00
Due Date: Nov 30
Gross Amount: $0.00
Net Balance: $0.00
Left to go: $100.00
Make donations with PayPal!

Latest GitHub Commits