This is not enough information to identify the issue, sorry.How do you see that the charset is switched?What default charsets are defined for databasemanagementsystem, database, database table?Which charsets are defined for your datafields?

if the charsets of your database are all setted correct but you get symbols anyways, you have to check the charset of your scripts which put the data to the database and the database connection too.

best wishes,Altrea

We don't provide any support via personal channels like PM, email, Skype, TeamViewer!

Hey Altrea, sorry for the lack of details ill try to be as thorough as possible from now on.

Ive got this book about PHP 5 ive been reading and couple of its final chapters are about databases and the Structured Query Language(SQL).Now the book recommends using MySQL Server to handle databases with php which already comes with XAMPP so thats all good.

First thing im being taught is how to use MySQL through the command line(much like we did with php) but for some reason that proves tobe harder. While booting MySQL.exe using CMD along with the welcome, command syntax and copyright messages i get these two lines:

mysql: Unknown OS character set 'cp862'.mysql: Switching to the default character set 'latin1'.

Now bare in mind that today is the first time ive learned about this language and my knowledge about it is very limited, so my ability toanswer your debugging question will also be limited, but i promise to do my best and to wrap this is up i really wont mind if you guys talkedto me like you're teaching a child

Altrea wrote:How do you see that the charset is switched?What default charsets are defined for databasemanagementsystem, database, database table?Which charsets are defined for your datafields?Altrea

1) I notice the switch obviously from the promt i get about the unknown char set and then the actual switch2) No idea how to answer that one , sorry3) huh?

Altrea wrote:if the charsets of your database are all setted correct but you get symbols anyways, you have to check the charset of your scripts which put the data to the database and the database connection too.

Well obviously my databases are all NOT setted correctly seeing as soon as MySQL starts up it switches from a char set that supports hebrew(cp862) to one that doesnt(latin1).

Isnt there a way to change the default character set for the whole server to utf8?And why doesnt microsoft just make windows operate that way too, from what i looked up its like a one-size-fits-all kind of solution....

P.S: Hebrew characters wont show normally even when created and stored with php at runtime.....

A. This is a quick side note - AFAIK, only the MS Professional and Enterprise Desktop OS products directly support multi-lingual operation. I use English, Spanish, Basque & French all on the same machine (I have a second keyboard also). The Home & Starter products (again - as far as I know) - are distributed in localized versions only. OEM MFR's zone-code their machines, much like DVD's.

B. When you say 'the server', you must understand 'the server' is really a suite of programs from completely separate sources, all of which have individual configuration files.