Ïðîáëåìà ñ êîäèðîâêîé â mysql - SA-MP Forums

Red391 · 03/06/2012, 08:32 PM

Çäðàâñòâóéòå âñå æåëàþùèå ïîìî÷ü
Ïðè âûâîäå ðóññêèõ áóêâ èç áä - ïîëó÷àþ êàðàêóëè.

Òåìû íà ôîðóìå èñêàë (âñå ÷òî íàø¸ë - íå ïîìîãëè)

Â áä â òàáëèöå â ÿ÷åéêå ñòîèò êîäèðîâêà utf8

Ïðè êîííåêòå 3 çàïðîñà âûïîëíÿþ:

Code:

mysql_set_charset("utf8_general_ci");
mysql_query("SET NAMES 'utf8'");
mysql_query("SET CHARACTER SET 'utf8'");

Ïðîøó ïîìîùè, òàê êàê âñ¸, ÷òî ìîã óæå èñïðîáîâàë. Çàðàíåå áëàãîäàðåí

The_Creator · 03/06/2012, 09:11 PM

Ïîïðîáóéòå òàêèì îáðàçîì:

Code:

mysql_set_charset ("cp1251");
mysql_query("SET NAMES 'cp1251'");

Red391 · 03/06/2012, 09:40 PM

Ñìåíà êîäèðîâêè ðåøèò ïðîáëåìó, íî ýòî íå òî ÷òî ìíå íóæíî.
utf8 îáøèðíåå, ïîòîìó è ïûòàþñü ðàçîáðàòüñÿ ñ íåé.
Âñ¸ æå, ñïàñèáî çà ïîìîùü.

jhonyxakep · 03/06/2012, 10:45 PM

Quote:

mysql_set_charset("utf8_general_ci");
mysql_query("SET NAMES 'utf8'");
mysql_query("SET CHARACTER SET 'utf8'");

ß à ýòîì íå îñîáî øàðþ, íî ðàçâå íå

mysql_set_charset("utf8");
mysql_query("SET NAMES 'utf8'");
mysql_query("SET CHARACTER SET 'utf8'");

?

Red391 · 04/06/2012, 12:00 AM

Ê ñîæàëåíèþ äàííîå èñïðàâëåíèå òîæå íå ïîìîãëî

jhonyxakep · 04/06/2012, 04:03 AM

mysql_set_charset("utf8_general_ci");
mysql_query("SET NAMES 'utf8_general_ci'");
mysql_query("SET CHARACTER SET 'utf8_general_ci'");

Âû ñíà÷àëà ïîïðîáóéòå ïåðåáðàòü íåñêîëüêî âàðèàíòîâ.

eakwarp · 04/06/2012, 05:12 AM

À çà÷åì âîîáùå óñòàíàâëèâàòü êîäèðîâêó òàêèì îáðàçîì? Ó íóæíîãî ïîëÿ óæå âûñòàâëåíà íóæíàÿ êîäèðîâêà, åñëè î÷åíü õî÷åòñÿ, ìîæíî è íà âñþ áä åå âûñòàâèòü.

Stepashka · 04/06/2012, 05:34 AM

Ãëàâíûé âîïðîñ: ñ êîäèðîâêîé çàïðîñîâ ïîíÿòíî, à âîò êîäèðîâêà áä â utf8_general_ci?

Quote:

Originally Posted by jhonyxakep

ß à ýòîì íå îñîáî øàðþ, íî ðàçâå íå

mysql_set_charset("utf8");
mysql_query("SET NAMES 'utf8'");
mysql_query("SET CHARACTER SET 'utf8'");

?

íåò.

Red391 · 04/06/2012, 05:48 AM

ß ïåðåáðàë íåñêîëüêî âàðèàíòîâ, êîãäà ïðîáîâàë ïåðâûé. Íè utf8, íå utf8_general_ci íå ïîìîãàþò.

Quote:

à âîò êîäèðîâêà áä â utf8_general_ci?

Äà, èìåííî â utf8_general_ci, âñÿ áä, è âñ¸ ÿ÷åéêè è ñòîëáöû.

Red391 · 04/06/2012, 07:04 PM

Êòî íèáóäü çíàåò - êàê ðåøèòü ýòó ïðîáëåìó?
Ñ êîäèðîâêîé çàïðîñà è ñ êîäèðîâêîé áä âñ¸ â ïîðÿäêå.
×òî åù¸ ìîæåò âëèÿòü?

03/06/2012, 08:32 PM	#1
Red391 Little Clucker Join Date: May 2012 Posts: 42 Reputation: 0	Ïðîáëåìà ñ êîäèðîâêîé â mysql Çäðàâñòâóéòå âñå æåëàþùèå ïîìî÷ü Ïðè âûâîäå ðóññêèõ áóêâ èç áä - ïîëó÷àþ êàðàêóëè. Òåìû íà ôîðóìå èñêàë (âñå ÷òî íàø¸ë - íå ïîìîãëè) Â áä â òàáëèöå â ÿ÷åéêå ñòîèò êîäèðîâêà utf8 Ïðè êîííåêòå 3 çàïðîñà âûïîëíÿþ: Code: mysql_set_charset("utf8_general_ci"); mysql_query("SET NAMES 'utf8'"); mysql_query("SET CHARACTER SET 'utf8'"); Ïðîøó ïîìîùè, òàê êàê âñ¸, ÷òî ìîã óæå èñïðîáîâàë. Çàðàíåå áëàãîäàðåí

03/06/2012, 09:11 PM	#2
The_Creator Big Clucker Join Date: Mar 2012 Posts: 158 Reputation: 17	Re: Ïðîáëåìà ñ êîäèðîâêîé â mysql Ïîïðîáóéòå òàêèì îáðàçîì: Code: mysql_set_charset ("cp1251"); mysql_query("SET NAMES 'cp1251'");

03/06/2012, 09:40 PM	#3
Red391 Little Clucker Join Date: May 2012 Posts: 42 Reputation: 0	Re: Ïðîáëåìà ñ êîäèðîâêîé â mysql Ñìåíà êîäèðîâêè ðåøèò ïðîáëåìó, íî ýòî íå òî ÷òî ìíå íóæíî. utf8 îáøèðíåå, ïîòîìó è ïûòàþñü ðàçîáðàòüñÿ ñ íåé. Âñ¸ æå, ñïàñèáî çà ïîìîùü.

04/06/2012, 12:00 AM	#5
Red391 Little Clucker Join Date: May 2012 Posts: 42 Reputation: 0	Re: Ïðîáëåìà ñ êîäèðîâêîé â mysql Ê ñîæàëåíèþ äàííîå èñïðàâëåíèå òîæå íå ïîìîãëî

04/06/2012, 04:03 AM	#6
jhonyxakep Gangsta Join Date: May 2011 Location: Russia, Vladivostok Posts: 729 Reputation: 43	Re: Ïðîáëåìà ñ êîäèðîâêîé â mysql mysql_set_charset("utf8_general_ci"); mysql_query("SET NAMES 'utf8_general_ci'"); mysql_query("SET CHARACTER SET 'utf8_general_ci'"); Âû ñíà÷àëà ïîïðîáóéòå ïåðåáðàòü íåñêîëüêî âàðèàíòîâ. __________________ ENG: System Control Useful Functions\|Server Side Radio Station plugin RUS: Server Side Radio Station \| System Control Plugin

04/06/2012, 05:12 AM	#7
eakwarp High-roller Join Date: Feb 2007 Posts: 1,035 Reputation: 96	Re: Ïðîáëåìà ñ êîäèðîâêîé â mysql À çà÷åì âîîáùå óñòàíàâëèâàòü êîäèðîâêó òàêèì îáðàçîì? Ó íóæíîãî ïîëÿ óæå âûñòàâëåíà íóæíàÿ êîäèðîâêà, åñëè î÷åíü õî÷åòñÿ, ìîæíî è íà âñþ áä åå âûñòàâèòü. __________________ More than 6 years of development, more than 320,000 lines of source code, more than a one hundred units and more than 8100 revisions. Valakas Roleplay - choose your role. Valakas Roleplay on Twitter [Gamemode] Valakas Trucker Roleplay (Russian).

04/06/2012, 07:04 PM	#10
Red391 Little Clucker Join Date: May 2012 Posts: 42 Reputation: 0	Re: Ïðîáëåìà ñ êîäèðîâêîé â mysql Êòî íèáóäü çíàåò - êàê ðåøèòü ýòó ïðîáëåìó? Ñ êîäèðîâêîé çàïðîñà è ñ êîäèðîâêîé áä âñ¸ â ïîðÿäêå. ×òî åù¸ ìîæåò âëèÿòü?

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Ïðîáëåìà ñ mysql	Hawkins	Русский/Russian	6	28/05/2012 11:56 AM
[MySQL]Ïðîáëåìà ñ êîäèðîâêîé...[Help]	dinnamo1927	Русский/Russian	2	08/04/2012 06:17 PM
Ïðîáëåìà ñ MySQL Ðåãèñòðàöèÿ	AnGeL_KRAMER	Русский/Russian	8	01/04/2012 03:22 PM
Ïðîáëåìà ñ MySQL	Splav	Русский/Russian	1	05/01/2012 03:22 PM
Ïðîáëåìà ñ MySQL íà CentOS 6.0	sniper-termit	Русский/Russian	11	19/09/2011 07:45 PM