character problem

yokolucu · 02-02-2010

Hi,
I trasformed my old dictionary database for php dict. (turkish to eng and eng to turkish).
However the descriptions with turkish chars and titles aren't stored exactly.
How?
Let me explain with an image.(I can't use it because of the post restrict)

Code:

Content visible to registered users only.

Code:

Content visible to registered users only.

but it is written in this way in .sql

Code:

Content visible to registered users only.

it must be shown on the screen like this :

Code:

Content visible to registered users only.

When it comes to Turkish characters it doesn't store and show the rest of the entry.

What can i do here or on mysql?

Code:

Content visible to registered users only.

**James** · 02-02-2010

look in func.php

find
function htmlesc($text) {
$text = stripslashes(htmlspecialchars($text, -1, 'ISO-8859-15'));
change the ISO-8859-15 to UTF-8

yokolucu · 02-02-2010

:( It didn't work.

yokolucu · 02-02-2010

I reinstalled the script and now the problem is

?
When i change charsets ,title and desc are ok but search results don't show turkish chars.
When I did some other changes ,then vice versa. Search results are ok but title is out of order.
Check it pls

Code:

Content visible to registered users only.

**James** · 02-02-2010

edit that function again above that I listed and set the charset to the utf8 or the one for turkish

yokolucu · 02-02-2010

Code:

Content visible to registered users only.

I did it but as i said above : When I used UTF-8 , the search results were shown correctly,howver, the title and description were non-turkish chars then.
When I tried another charset,the search results were then non-turkish chars., however title and des were ok.

I can't see everything ok under a charset

02-02-2010	#1
yokolucu Join Date: Feb 2010 Posts: 4	character problem Hi, I trasformed my old dictionary database for php dict. (turkish to eng and eng to turkish). However the descriptions with turkish chars and titles aren't stored exactly. How? Let me explain with an image.(I can't use it because of the post restrict) Code: Content visible to registered users only. Code: Content visible to registered users only. but it is written in this way in .sql Code: Content visible to registered users only. it must be shown on the screen like this : Code: Content visible to registered users only. When it comes to Turkish characters it doesn't store and show the rest of the entry. What can i do here or on mysql? Code: Content visible to registered users only.

02-02-2010	#2
James :) phpLD Support *phpLD Administrator* Supporter Moderator Join Date: Aug 2006 Location: Nanaimo, BC , Canada Posts: 24,014	look in func.php find function htmlesc($text) { $text = stripslashes(htmlspecialchars($text, -1, 'ISO-8859-15')); change the ISO-8859-15 to UTF-8 __________________ Attention: For Support Please Read this thread. IF the domain is not listed in your PhpLD users area and it is 3.x You will have to list it before ANY questions are answered. My paypal is rentawebmaster @ gmail.com ^^ if I have helped you help me I need a new laptop PhpLD Recommended Hosting: Here They work with you not against you Live Directory

02-02-2010	#3
yokolucu Join Date: Feb 2010 Posts: 4	:( It didn't work. Last edited by yokolucu; 02-02-2010 at 11:43 AM.

02-02-2010	#4
yokolucu Join Date: Feb 2010 Posts: 4	I reinstalled the script and now the problem is ? When i change charsets ,title and desc are ok but search results don't show turkish chars. When I did some other changes ,then vice versa. Search results are ok but title is out of order. Check it pls Code: Content visible to registered users only.

02-02-2010	#5
James :) phpLD Support *phpLD Administrator* Supporter Moderator Join Date: Aug 2006 Location: Nanaimo, BC , Canada Posts: 24,014	edit that function again above that I listed and set the charset to the utf8 or the one for turkish __________________ Attention: For Support Please Read this thread. IF the domain is not listed in your PhpLD users area and it is 3.x You will have to list it before ANY questions are answered. My paypal is rentawebmaster @ gmail.com ^^ if I have helped you help me I need a new laptop PhpLD Recommended Hosting: Here They work with you not against you Live Directory

02-02-2010	#6
yokolucu Join Date: Feb 2010 Posts: 4	Code: Content visible to registered users only. I did it but as i said above : When I used UTF-8 , the search results were shown correctly,howver, the title and description were non-turkish chars then. When I tried another charset,the search results were then non-turkish chars., however title and des were ok. I can't see everything ok under a charset

Currently Active Users Viewing This Thread: 1 (0 members and 1 guests)