The vB Geek

Go Back   The vB Geek > vB Geek Products > Geek Auto-Linker

Geek Auto-Linker GAL automatically links keywords that users type in posts to advertising hover pop-ups.

Advertisement
  Learn how to remove ads

Reply
 
Thread Tools Display Modes
  #1  
Old 02-09-2008, 04:15 PM
batox batox is offline
Junior Member
 
Join Date: Feb 2008
Posts: 4
Geek Auto-Linker Pro License Holder 
Default Problem with Turkish Characters

hi,

Turkish letters (şığç) make problems..

to example ş becomes in database as 351 stores..

How can I eliminate this problem?
Reply With Quote
  #2  
Old 02-09-2008, 05:41 PM
Morgan's Avatar
Morgan Morgan is offline
Administrator
 
Join Date: Jul 2006
Posts: 2,255
Geek Article and Review System License Holder GeekMart License Holder Geek Auto-Linker Pro License Holder Geek Advertising Banner License Holder Geek Gazette License Holder 
Default

phpMyAdmin -> choose database -> choose table -> click Operations tab -> set Collation to whatever character set you wish to use - if not sure, look at the Collation value from another table that stores characters the way you want.

Also see http://www.vbulletin.com/forum/showthread.php?t=259250 for other suggestions.
__________________
Please use the forums for support, feature requests, and similar such things. Support does not include custom code, custom template edits, or third-party modifications. PMs and emails to me should be for private information only, such as login information. If you PM or email me a support question, chances are good that I'll ignore it. Thanks.
While the work or play is on, it is a lot of fun if while you are doing one you don't constantly feel that you ought to be doing the other. -- Franklin Pierce Adams
Reply With Quote
  #3  
Old 02-09-2008, 06:04 PM
batox batox is offline
Junior Member
 
Join Date: Feb 2008
Posts: 4
Geek Auto-Linker Pro License Holder 
Default

these problems develops if I over admin panel one word register

if I register over phpmyadmin manuel word, it is indicated correctly.. but none autolink with Turkish characters..

you can please try this word here: baþý
Reply With Quote
  #4  
Old 02-09-2008, 07:37 PM
Morgan's Avatar
Morgan Morgan is offline
Administrator
 
Join Date: Jul 2006
Posts: 2,255
Geek Article and Review System License Holder GeekMart License Holder Geek Auto-Linker Pro License Holder Geek Advertising Banner License Holder Geek Gazette License Holder 
Default

It is the ISO-8859-9 that makes baþý appear on screen as the word başı but if you type the word başı it is saved on this site as ba& #351;& #305; (without spaces) because this site uses ISO-8859-1 and not ISO-8859-9 so no match is found.

If you are seeing ba351305 instead of başı in the ACP, then the page encoding is not correct. Make sure you are using ISO-8859-9 when entering keywords via the ACP. Also, as your site is ISO-8859-9, try latin5_turkish_ci as the Collation on the gal database table.

The next thing to do is try a different regular expression. Here are a few that you can try. Once you've added them, go to Categories and select a new regular expression from the drop down menu, and then run both 'Cache' options in the maintenance section:
Code:
#(($1)(?=[^>]*<)(?![^<]*</))#im

#(\b($1)(?=[^>]*<)(?![^<]*</))#im

#(\b($1)\s(?=[^>]*<)(?![^<]*</))#im

#(\s($1)\s(?=[^>]*<)(?![^<]*</))#im
Given different encodings, post formats, PHP settings, etcetera, it is difficult to provide a one size fits all regular expression, so you might need to try different ones until you find one you prefer, though the 'standard' regexp may work also.
__________________
Please use the forums for support, feature requests, and similar such things. Support does not include custom code, custom template edits, or third-party modifications. PMs and emails to me should be for private information only, such as login information. If you PM or email me a support question, chances are good that I'll ignore it. Thanks.
While the work or play is on, it is a lot of fun if while you are doing one you don't constantly feel that you ought to be doing the other. -- Franklin Pierce Adams
Reply With Quote
  #5  
Old 02-09-2008, 08:07 PM
batox batox is offline
Junior Member
 
Join Date: Feb 2008
Posts: 4
Geek Auto-Linker Pro License Holder 
Default

I made ISO-8859-9 now and everything is ok now

thanks so much Morgan!
Reply With Quote
Reply

Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off

Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
Problem with greek characters lthanos Geek Article and Review System 3 12-29-2009 08:47 AM
Turkish Christians Forum orciux GARS Link Directory 0 11-23-2008 09:27 AM
Problem with some norwegian characters in GAL Frogger Geek Auto-Linker 1 07-09-2008 02:36 PM
Problem with Characters MrD Geek Auto-Linker 11 01-31-2008 05:11 PM
Special Characters SpadMan Geek Auto-Linker 2 12-03-2005 05:35 PM


All times are GMT. The time now is 11:58 AM.


Powered by vBulletin® Version 3.8.5
Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.