ako je u pitanju MySQL db mozda ce ti pomoci ovaj primer sa php.net (u delu za opis iconv funkcije)
Citat:
If you don't have iconv, you can use MySQL to do the conversion.
Note that to do this you have to use MySQL's charset names, which are different than iconv names (e.g. "utf8" instead of "utf-8").
<?php
/**
* @param $string
* @param $from [string] The name of the current character set of $string, in MySQL format (e.g. "utf8", "hebrew").
* @param $to [string] The name of the character set to which you want to convert $string.
* @author Erel Segal - Rent a Brain (
http://tora.us.fm/rentabrain)
* @date 2006-12-10
*/
function mysql_iconv($string, $from, $to) {
// keep current character set values:
$character_set_database = mysql_result(mysql_query("SELECT @@character_set_client"),0,0);
$character_set_results = mysql_result(mysql_query("SELECT @@character_set_results"),0,0);
mysql_query("SET character_set_client=$from");
mysql_query("SET character_set_results=$to");
$string_escaped = mysql_real_escape_string($string);
$converted_string = mysql_result(mysql_query("SELECT '$string_escaped'"),0,0);
// restore previous character set values:
mysql_query("SET character_set_client=$character_set_database");
mysql_query("SET character_set_results=$character_set_results");
return $converted_string;
}
neki od mysql char setova koji bi ti trebali za gornju funkciju:
-cp1250 (Windows Central European)
cp1250_bin Central European (multilingual), Binary
cp1250_croatian_ci Croatian, case-insensitive
-cp1251 (Windows Cyrillic)
cp1251_bin Cyrillic (multilingual), Binary
cp1251_general_ci Cyrillic (multilingual), case-insensitive
cp1251_general_cs Cyrillic (multilingual), case-sensitive
-cp850 (DOS West European)
cp850_bin West European (multilingual), Binary
cp850_general_ci West European (multilingual), case-insensitive
cp852 (DOS Central European)
cp852_bin Central European (multilingual), Binary
cp852_general_ci Central European (multilingual), case-insensitive
-latin2 (ISO 8859-2 Central European)
latin2_bin Central European (multilingual), Binary
latin2_croatian_ci Croatian, case-insensitive
latin2_general_ci Central European (multilingual), case-insensitive
-utf8 (UTF-8 Unicode)
utf8_bin Unicode (multilingual), Binary
-latin1 (cp1252 West European)
latin1_bin West European (multilingual), Binary
latin1_general_ci West European (multilingual), case-insensitive
latin1_general_cs West European (multilingual), case-sensitive
....
....
....
itd...
a imas i funkcije u php koje rade konvertovanje:
mb_convert_encoding
iconv
htmlentities
convert_cyr_string
pa probaj da izkombinujes...
pozdrav
prikaz nasih slova i utf8_unicode_ci
