[LUGOS] phpmyadmin & mysql

Klemen Humerca klemen at humerca.com
Mon Jun 6 15:36:43 CEST 2005


Hvala.

Zadeva deluje ampak samo, ce v libraries/select_lang.lib.php 
zakomentiram sl-utf-8 in s tem izsilim prijavo:

  MySQL kodna tabela:  Windows Central European (cp1250)

Seveda sem moral spremeniti se default charset za tabelo:

ALTER TABLE table CONVERT TO CHARACTER SETcp1250


No glavno, da deluje.

Hvala.



Klemen Humerca

-----e-mail&web---------
  klemen at humerca.com
  forum.humerca.com
------------------------



Marko Bevc wrote:
> res so težave...probaj forcnit vse na latin ali cp1250
> ...pa v my.cnf:
> 
> [mysqld]
> default-character-set=latin2
> default-collation=latin2_general_ci
> init-connect="SET NAMES latin2"
> 
> [mysql]
> default-character-set=latin2
> default-collation=latin2_general_ci
> 
> (menda mysql4.1 dela interno vse na utf8 in je potrebno malo več dela za
> preklop na latin2)
> 
> lp,
> Marko
> 
>>Uporabljam mysql 4.1 (rpm) in phpmyadmin 2.6.2-pl1. Ko se zelim prijaviti
>>v PMA
>>izberem jezik Slovenian (sl-win1250). Ko se prijavim vidim tole:
>>
>>Language: Slovenian (sl-utf-8)
>>MySQL kodna tabela:  UTF-8 Unicode (utf8)
>>
>>Sploh ne morem spremeniti jezika (tabele) v kaj drugega kot sl-utf-8, ker
>>sploh
>>ni druge moznosti za izbrat. SHOW VARUABLES izpise sledece podatke:
>>
>>character_set_client utf8
>>character_set_connection utf8
>>character_set_database latin1
>>character_set_results utf8
>>character_set_server latin1
>>character_set_system utf8
>>
>>DEFAULT CHARSET za tabelo je latin1. Ce spremenim DEFAULT CHARSET v cp1250
>>ali
>>latin2 ni nobene razlike. V my.cnf sem dodal DEFAULT-CHARACTER-SET=cp1250
>>in
>>potem se latin2, ampak ni bilo spremembe. Poskusil sem tudi posamezno
>>konverzijo (http://dev.mysql.com/doc/mysql/en/charset-conversion.html) pa
>>tudi
>>nic.
>>
>>Kaj moram storiti, da se mi odpre PMA v jeziku Slovenian (sl-win1250),
>>potem da
>>vnasam in vidim podatke v windows-1250 tabeli?
>>
>>Hvala.
>>
>>
>>--
>>
>>Klemen Humerca
>>
>>-----e-mail&web---------
>> klemen at humerca.com
>> www.humerca.com
>> forum.humerca.com
>>------------------------
>>
>>     .-.
>>     /v\
>>    // \\
>>   /(   )\
>>    ^^-^^
>>
>>
>>
>>
>>_______________________________________________
>>lugos-list mailing list
>>lugos-list at lugos.si
>>http://liste2.lugos.si/cgi-bin/mailman/listinfo/lugos-list
>>
> 
> 
> _______________________________________________
> lugos-list mailing list
> lugos-list at lugos.si
> http://liste2.lugos.si/cgi-bin/mailman/listinfo/lugos-list
> 


More information about the lugos-list mailing list