[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