CODEWITHSUNDEEP
phpmysql
Rednas
Rednas

Reputation: 609

charset mysql db

i was working on a website for family but i fount a problem i can't fix and google didn't help either..

i had a problem with transoprt of a website i made, i made the website database in latin1-swedish-ci.
but the website is made in uft-8, no problems on my host but when i transported the web page i see everywhere a question mark.
my question is how to make the database work with the char set utf-8. i tryed to make the collection to utf8-bin but nothing happents.

Thankyou,

Sander

( sorry for my poor english )

Upvotes: 1

Views: 118

Answers (1)

Milad Naseri
Milad Naseri

Reputation: 4118

You could either establish the connection via charset latin-swedish-ci and get the data correctly, or change the data inside the database into utf8 (via mysql_set_charset('utf8', $link);).

Remember that by changing the charset for data, I mean doing it for the database, table, and the fields. Not just the database, or the table.

Upvotes: 2

Related Questions