Apache2Triad Help, Support and Development Forum Index Search Profile Log in to check your private messages Log in Register Memberlist Attachments Statistics Crew/Ranks Archive
 Problem with MySQL charset.
Google
Post new topic Reply to topic
Author Message
helloworld
 
 


Joined: 01 Mar 2006
Posts: 1

PostPosted: Wed Mar 01, 2006 1:09 pm Reply with quoteBack to top

I want change SQL charset to iso-8859-1, who can help me, now I using charset UTF-8, when i backup data an restore on host, the data don't show correct.
How to change Language in phpMyadmin from en-utf-8 to en-iso-8859-1.
Help me..
Thanks.
View user's profileSend private message
dawg
support
support


Joined: 11 Apr 2004
Posts: 180

PostPosted: Wed Mar 01, 2006 8:09 pm Reply with quoteBack to top

http://dev.mysql.com/doc/refman/5.0/en/charset-connection.html

http://dev.mysql.com/doc/refman/5.0/en/charset-we-sets.html

Quote:


latin1 is the default character set. MySQL's latin1 is the same as the Windows cp1252 character set. This means it is the same as the official ISO 8859-1 or IANA (Internet Assigned Numbers Authority) latin1, but IANA latin1 treats the code points between 0x80 and 0x9f as “undefined,” whereas cp1252, and therefore MySQL's latin1, assign characters for those positions. For example, 0x80 is the Euro sign. For the “undefined” entries in cp1252, MySQL translates 0x81 to Unicode 0x0081, 0x8d to 0x008d, 0x8f to 0x008f, 0x90 to 0x0090, and 0x9d to 0x009d.



Choose the Coloation from the operations section of the Database should change the Charset.


Or from the SQL Section :

Code:

ALTER DATABASE  `DBName` DEFAULT CHARACTER SET latin1_swedish_ci COLLATE latin1
View user's profileSend private message
Display posts from previous:      
Post new topic Reply to topic


 Jump to:   



View next topic
View previous topic
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum
You cannot attach files in this forum
You cannot download files in this forum
Powered by phpBB © 2001, 2002 phpBB Group :: FI Theme
All times are GMT