WampServer

how can I configure the information on the picture below?

[www.kooneo.com]

none of these are php configuration


there a mysql database config



goto http:/ /localhost/phpmyadmin


select the databse and you can change them all there

Steven Martin
stevenmartin99@gmail.com
stevenmartin99@hotmail.com
PampServer.com - [pampserver.com]

thank you if you see the pictures you will see

1-character set client

2-character set connection

3- character set Server

4- character set database

5-character set system


Can I change those on http:/ /localhost/phpmyadmin or just the Character set database? I want to be able to alter all of the 5 I have point to above, is that possible?


if you see the picture below below you will see the screenshoot has Server, connection, DB, and Client set to utf8 is that possible to configure? where?





Edited 1 time(s). Last edit at 12/15/2009 08:01PM by joelitos.

oh i got ya

well you can change all the global values

by adding


default-character-set=ascii


for example to the my.ini file

then restart wamp

Steven Martin
stevenmartin99@gmail.com
stevenmartin99@hotmail.com
PampServer.com - [pampserver.com]

should this is my.ini configuratioin as below I added the default-character-set=ascii line you told me. Is the set up below ok?

; As of 4.0b4, PHP always outputs a character encoding by default in
; the Content-type: header. To disable sending of the charset, simply
; set it to be empty.
;
; PHP's built-in default is text/html
default_mimetype = "text/html"
default_charset = "utf8"
default-character-set=ascii

change the ascii to watever u need




yes just make sure its in the my.ini and not the php.ini

Steven Martin
stevenmartin99@gmail.com
stevenmartin99@hotmail.com
PampServer.com - [pampserver.com]

default-character-set=utf8

Changes


1-character set client

2-character set connection

4- character set database

but not the Server characterset

Still the Server Characterset display as:


Server characterset: latin1


it still display as:





with the line you gave in the previous post?

is there another way to change the Server Characterset?

What about through MySQLInstanceConfig application? i don't know how to run it properly though. I ran this application a couples of hours ago and i had to uninstall the wamp server and install it again becuase I messed it up basically..

help..

then use

character-set-server=utf8



as well in the my.ini

are you sure u need to change all these? for example the client one may have undesired effects

Steven Martin
stevenmartin99@gmail.com
stevenmartin99@hotmail.com
PampServer.com - [pampserver.com]

I want everything to be utf8 I might be doing something wrong don't know

when i change the default-character-server=utf8

then mysql console will open and close right away



Edited 1 time(s). Last edit at 12/15/2009 09:20PM by joelitos.

didnt that change it? make sure u restart mysql each time...

Steven Martin
stevenmartin99@gmail.com
stevenmartin99@hotmail.com
PampServer.com - [pampserver.com]

I have to put

default-character-server=utf8

in both

php.ini

and

my.ini?

do i have to put a semi and colon before

like

;default-character-server=utf8



Edited 1 time(s). Last edit at 12/15/2009 09:33PM by joelitos.

nooo
the ; disables it


only in the my.ini


these are mysql settings not php settings

Steven Martin
stevenmartin99@gmail.com
stevenmartin99@hotmail.com
PampServer.com - [pampserver.com]