php mysql kai provlima sto charset

[dominant]

Gia xara se olous

 

Exo provlima me ton tropo pou kataxorountai ta ellhnika sthn Mysql 4.1.10a

meso html formas kai php 4.3.10

 

sto my.cnf ths mysql exo

 

default-character-set=greek

 

stn html selida exo 8esei iso-8859-7

 

parola auta ta ellhnika mefanizontai os

 

???????????

????????

 

Ti provlima na uparxei?

[random]

που εμφανιζονται ετσι? στον browser, σε εργαλειο διαχειρισης της βασης?

μηπως ειναι σωστα αποθηκευμενα, αλλα φταιει αυτος που τα εμφανιζει?

[or1onas]

An anoixeis konsola k mpeis sth mysql, mporeis na deis swsta ta records?

[dominant]

pali ????????? emfanizontai ta ellhnika kai apo thn consola h opoia exei locale EN_us

 

To parakseno einai oti se allo virtual host tou apache exo stisei ena phpbb2 2.0.17 to opoio den exei problima me ta elhnika.

[dominant]

telika anagkastika na allakso sthn vash to collation se latin prokeimenoun na doulepsoun ta ellhnika sthn selida.

[Crawl_From_Death]

Egw sta site pou sthnw, sto config arxeio grafw ta ekshs:

 

$link = mysql_connect($db_host, $db_user, $db_pass);

mysql_query('set character set greek',$link);

mysql_query("SET NAMES 'greek'",$link);

 

kai ola douleuoun ok :grin:

[dominant]

nai omos apo konsola vlepeis ellhnika?

Poia ekdosh mysql exeis? Kai emena sthn 4.0.20 douleuan ola mia xara

me default charset = greek

[Crawl_From_Death]

Xrhsimopoiw thn 4.1.14..

[dominant]

mporei auth pou xrisimopoio ego na exei bug me ta charset

[thanv]

meta apo arketes meres piramatismous kai diavasmatos diaforon forum, oi entoles pou edoses edo me esosan!!!!

eho se server, ameriki meria, mysql 4.1.13 kai myphpadmin 2.6.4

ekana database me to mysql kai katopin pinaka me myphpadmin. oles oi rythmisis gia ta ellinika itan sostes.

H DB ixe DEFAULT CHARACTER SET greek COLLATE greek_general_ci;

ke to collation ton pedion greek_general_ci; Afta ta eftiahna apo to myphpadmin, yparhoun epiloges.

mesa apo to myphpadmin evlepa ta stihia tou pinaka ok, ellinika. apo tin selida omos mou evgaze ??????? Hrisimopio ke ena programa php gia na emfaniso ta stihia tou pinaka sti selida. To charset=ISO-8859-7.

Telika afto pou eftege itan oti prepi molis gini connect ke select o DB na mpoun i entoles pou egrapse o filos edo.

 

@mysql_query('set character set greek');

@mysql_query("SET NAMES 'greek'");

 

elpizo na voithiso ke allous pou ehoun afto toprovlima

[panosru]

nai opos ta leei o filos thanv einai, ayta ysxyoun apo MySQL 4.1+

Apo MySQL 4.1+ h MySQL aneptykse ena, poly kalytero apo tis prohgoumenes ekdoseis ths, systhma diaxeirhshs ton glosson, alla den ftanei mono to systhma gia na doulepsei sosta prepei na orizoume greek_general_ci Collation sthn Database kai sta Fields mas pou periexoun String xarakthres.

kai sthn synexeia fysika na trexoume ta 2 query opos poly sosta anefere o thanv ALLA oxi prin thn mysql_select_db() alla akribos kato apo ayth. Fysika enohte pos se periptosh pou kanoume multi manipulation ton database mas meta apo kathe mysql_select_db() pou trexoume meta apo kapoio mysql_connect() to opoio exoume ksanakanei epidi kaname mysql_close() thn prohgoumenh bash opou xeirozomastan, ekteloume ksana ta 2 ayta query's

 

PS: Ftiaxno mia Class gia Mail Sending tora molis teleioso aythn tha Ftiakso mia Class gia MySQL Connection ta opoia tha ta kano release edo kai sto freestuff...

[dominant]

hello,

 

Exo dimiourgisei mia vasei me greek collation exo ftiaksei tous pinakes se greek collation, kano import apo sql arxeio (ellhnika) alla mou bgazoun ??? an kai dino sto (sqlyog client) names kai charset greek.

To provlima diladi den linete monoxa OTAN ftiakso thn vash kai tous pinakes se

latin1 kai kano import ta ellhnika data

kai doso names kai charset latin1, tote kai mono tote mporo na do ellhnika

 

Kserei kaneis ti paizei? Exo server 4.1.10a

[panosru]

exeis kanei thn Data Base sou se greek_general_ci Collation?

An den einai terastios o kodikas sou ths bashs sou kanton mia post edo mporei na ksexases na oriseis ta collations apo ekei (symbainei syxna otan kanoume export mia bash dedomenon apo palia mysql kai palio phpmyadmin se kainouria)

[dominant]

den kano export apo phpmyadmin alla apo to sqlyog (enas window client)

 

H vash h kainouria einai greek ( to default tou server einai greek) kai ta tables greek.

[panosru]

mporeis na kaneis post ton kodika apo to export?