Facebook  Twitter 

SMFHacks.com

+-

SMFHacks.com

+- User Information

Welcome, Guest.
Please login or register.
 
 
 
Forgot your password?

+- Forum Stats

Members
Total Members: 4257
Latest: Alex998.
New This Month: 1
New This Week: 0
New Today: 0
Stats
Total Posts: 43293
Total Topics: 7522
Most Online Today: 118
Most Online Ever: 2482
(April 09, 2011, 07:02:45 pm)
Users Online
Members: 0
Guests: 106
Total: 106

Author Topic: SMF Links and SMF Articles character set problem  (Read 12624 times)

0 Members and 1 Guest are viewing this topic.

Offline oskars

  • Member
  • *
  • Posts: 2
    • View Profile
SMF Links and SMF Articles character set problem
« on: February 21, 2011, 04:26:39 pm »
Hello!
I am using SMF 2.0 RC5 with UTF-8 language character set. (languages used latvian and russian).
I an using also language files to change interface and everything works Ok, including SMF inself, Simple portal and other mods.
The problem is with SMF Links and SMF Articles, which turns most of non-Latin characters to ? or some smily type.
As soon as I enter latvian characters like ēūīāšģķļžčņ or russian characters, for instance, Цитата от 13 Июня 2006, after submission these are no the same any more. The problem is with all the texts - category, topic, article text, link name e.t.c.

These mods are  cool, but as these characters are crippled, there is no use in languages having specific characters.
Please check it.

Offline SMFHacks

  • Administrator
  • Hero Member
  • *****
  • Posts: 16451
    • View Profile
Re: SMF Links and SMF Articles character set problem
« Reply #1 on: February 21, 2011, 04:28:53 pm »
Try changing the table type for the tables to utf8
Get your Forum Ranked! at https://www.forumrankings.net - find out how your forum compares with others!

Like What I do? Support me at https://www.patreon.com/vbgamer45/

Offline oskars

  • Member
  • *
  • Posts: 2
    • View Profile
Re: SMF Links and SMF Articles character set problem
« Reply #2 on: February 21, 2011, 04:48:48 pm »
Thanks for instant replay.
Must admit, that I am no expert in MySQL and table management. I using myadmin to do some things with it.
So I do not fully understand which of the parameters should I change:

Field name    
Data type    
Type width    
Type options    Case insensitive Case sensitive
Allow nulls?    Yes No
Default value    Don't change NULL Value
Part of primary key Yes No

As I understand, the main thing is type - but this is the same for most of tables - tinytext, text, longtext (not mentioning anything about character set used).

Offline SMFHacks

  • Administrator
  • Hero Member
  • *****
  • Posts: 16451
    • View Profile
Re: SMF Links and SMF Articles character set problem
« Reply #3 on: February 21, 2011, 04:52:48 pm »
It should be under Operations if you are using phpmyadmin you have to get inside the smf_links and smf_articles tables.
Get your Forum Ranked! at https://www.forumrankings.net - find out how your forum compares with others!

Like What I do? Support me at https://www.patreon.com/vbgamer45/

Offline hydrozagadka

  • Member
  • *
  • Posts: 1
    • View Profile
Re: SMF Links and SMF Articles character set problem
« Reply #4 on: September 10, 2011, 02:04:01 pm »
I operate on files, via Programmers Notepad, and I'm not sure where I should find these "tables" to change. I have the same problem with characters (utf-8 set) with SMF Articles, as Oskars earlier.

Offline SMFHacks

  • Administrator
  • Hero Member
  • *****
  • Posts: 16451
    • View Profile
Re: SMF Links and SMF Articles character set problem
« Reply #5 on: September 10, 2011, 06:42:19 pm »
Easier way would be to use phpmyadmin and change the tables to uft8 as the table type.
Get your Forum Ranked! at https://www.forumrankings.net - find out how your forum compares with others!

Like What I do? Support me at https://www.patreon.com/vbgamer45/

 

Related Topics

  Subject / Started by Replies Last post
0 Replies
3895 Views
Last post October 30, 2006, 07:01:36 pm
by wisebryce
4 Replies
5133 Views
Last post July 11, 2007, 11:05:51 pm
by 7forward
1 Replies
7653 Views
Last post August 12, 2008, 07:14:57 pm
by SMFHacks
2 Replies
4607 Views
Last post April 18, 2013, 08:08:35 pm
by MaryLou
0 Replies
7880 Views
Last post May 19, 2013, 07:03:27 am
by murdocklawless

+- Recent Topics

Rate own images by fvlog19
April 11, 2024, 10:56:53 am

Tidy Child Boards on 2.1.4 by SMFHacks
April 04, 2024, 03:54:12 pm

Problems SMF 2.0.19 > 2.1.4 SMF Gallery Pro - Recents Images to overall header by Michel68
March 30, 2024, 12:41:08 pm

Can't DROP 'id_member'; check that column/key exists Datei: by SMFHacks
March 30, 2024, 11:58:20 am

No thumbnails on new uploads by Tonyvic
March 29, 2024, 06:26:18 am

Display the Contact Page for guests by SMFHacks
March 27, 2024, 10:55:43 am

is it possible to add support for odysee.com by fvlog19
March 21, 2024, 08:47:51 am

Request for admin notification by davejo
March 10, 2024, 01:31:59 am

I need help with torrent upload by Ineedsmfhelp
March 09, 2024, 10:01:13 pm

an idea for new mod (( content type with different display )) by SMFHacks
February 27, 2024, 01:36:27 pm

Powered by EzPortal